The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
User | Count |
---|---|
26 | |
10 | |
8 | |
6 | |
6 |
User | Count |
---|---|
31 | |
11 | |
10 | |
10 | |
9 |