SUMX excluding duplicates and use it in tables and cards

[Anonymous]

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

[PaulDBrown]

@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)

[amitchandak · Accepted 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])))