Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
i found a bit strange that the total does not appear to be accurate especially when i use the measure as Cards.
The calculation of the 2nd column here is: Measure = SUMX(DISTINCT(vw_aps_mr2_returns_receipts_repair[Return Number]),MAX(vw_aps_mr2_returns_receipts_repair[Return Restocking Amount]))
When i use it as cards, it shows different value.
Can anyone help me why is this happening? and how should i fix it?
Thanks,
laedays
Solved! Go to Solution.
@Anonymous , Try like
SUMX(values(vw_aps_mr2_returns_receipts_repair[Return Number]),calculate(MAX(vw_aps_mr2_returns_receipts_repair[Return Restocking Amount])))
@Anonymous
I'm not sure if I'm reading this right, but your card displays a value of 587.81K (which is formatted in Thousands, rounded to 2 decimals) which is the "same" value as 587,809.72 (wich is displayed as units) seen in the lower table. The difference is the formatting (which you can change in the formatting pane if you wish)
Proud to be a Super User!
Paul on Linkedin.
@Anonymous , Try like
SUMX(values(vw_aps_mr2_returns_receipts_repair[Return Number]),calculate(MAX(vw_aps_mr2_returns_receipts_repair[Return Restocking Amount])))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |