Calculated Column Failure

[Anonymous]

Hello,

I am trying to calculate whether a distributor of mine is on my program or not. This can be calculated by seeing if the "gwp_distributor_lookup" is blank. If it is, then the distributor is not on my program. However, when I program my logic, the calculated column does not seem to calculating.

The below screenshot fairly well demonstrates my issue.

planned_distributor_check = 
IF(ISBLANK('2022_plan (10-2021)'[gwp_distributor_lookup])=True,"Planned For - Not on GWP", 
    IF(ISBLANK('2022_plan (10-2021)'[Distributor])=TRUE,"Not Planned For - on GWP","Planned For - on GWP"))

I can't use a measure because I need to incorporate the calculations into a measure. To my knowledge, you cannot use a measure in a slicer.

Any and all help would be greatly appreciated!

Thanks,

Joel

[v-rongtiep-msft · Accepted solution]

Hi @Anonymous ,

Please refer to my pbix file to see if it helps you.

Create a column.

planned_distributor_check!! =
IF (
    ( 'Table'[gwp_distributor_llookup] ) = BLANK ()
        || 'Table'[Contributor] = BLANK (),
    "Planned For - Not on GWP",
    "Planned For - on GWP"
)

If it does not help, please provide some sample data and your desired output (Preferably in picture form)

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks Polly!!! Works great