Forum Discussion
Calculated Column Failure
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
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.
2 Replies
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.