Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi,
Struggling with this. How can i pass a measure into an if/switch stament.
This will be used to format colours - not sure how to get around this
Measure = SWITCH(TRUE() , 'Calculations Table'[DSA%_Late] <> 'Construct_Supplier Ruling'[DSA_Amb_Target} & 'Construct_Supplier Ruling'[DSA_Grn_Target] , 3 )
Hi, @Jackbaz99
Invalid code can't help us understand your problem, please try to use pictures and text to describe your needs.
Best Regards,
Community Support Team _ Eason
Measures should never be preceded with the table name they reside in. On the other hand, columns should always be. Please stick to this rule because if you don't, others will have (and do have!) a very hard time reading and understanding the code. Thanks.