Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello,
I have look into the old topics but I didn't find an answer.
Simply speaking, I have built simple DAX for comparision of two values.
Color var_value_lining = SWITCH(True(),
SUM('Lining'[var_value])='Lining'[var_vall_check],
"#44B62D",
"#FF0000")
Where Lining [var_value] is a column but Lining [var_vall_check] is a measure.
Seems to be simple but almost all the time is showing reds even if those two values are equal.
Could you please advice some solution ?
Solved! Go to Solution.
Hi @MKPartner
How many decimal places does 'Lining'[var_value] have? You can try rounding the Measure to that number. If it's two, then use blow, adapt to the decimal places you have in the table
ROUND(var_vall_check], 2)
Joe
Proud to be a Super User! | |
Date tables help! Learn more
Thank you for support.
Hi @MKPartner
How many decimal places does 'Lining'[var_value] have? You can try rounding the Measure to that number. If it's two, then use blow, adapt to the decimal places you have in the table
ROUND(var_vall_check], 2)
Joe
Proud to be a Super User! | |
Date tables help! Learn more
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
85 | |
66 | |
51 | |
45 |
User | Count |
---|---|
216 | |
89 | |
82 | |
66 | |
57 |