For more information, refer to the following links: LOOKUPVALUE: https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax ISBLANK: https://docs.microsoft.com/en-us/dax/isblank-function-dax BLANK: https://docs.microsoft.com/en-us/dax/blank-function-dax