Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Jackbaz99
Helper I
Helper I

Passing measure into a calculated column

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 )

 

2 REPLIES 2
v-easonf-msft
Community Support
Community Support

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

daXtreme
Solution Sage
Solution Sage

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.

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.