topic Passing measure into a calculated column in DAX Commands and Tips

Passing measure into a calculated column

Jackbaz99 — Fri, 07 Oct 2022 08:26:05 GMT

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 )

Re: Passing measure into a calculated column

daXtreme — Fri, 07 Oct 2022 11:03:00 GMT

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.

Re: Passing measure into a calculated column

v-easonf-msft — Thu, 20 Oct 2022 10:13:11 GMT

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