Calculating Custom Measure for Matrix

[Zainhashmi]

Hi..

i need help with my measure below..

i am creating a measure for custom calculation.. the criteria is if the created measure has the value greater than '"0" than it should return the spending otherwise blank.. the formula working on row by row is perfectly fine

but for the totals.. it is showing the same amount of spend which is incorrect.. in this case where i am making the mistake.. would be very glad for your expert opinon.. 

Thanks

[v-lionel-msft · Accepted solution]

Hi @Zainhashmi ,

Please refer to my formula.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DataZoe]

@Zainhashmi You could try and add on line 47 (after the RETURN) a SUMX like so:

SUMX(VALUES('Table'[Vendor Name]),

then add another ) at the very end. That way it will figure it out per vendor (you can also do it for each row of the table if you drill down), then sum them up.

[Zainhashmi]

so when i am trying to aggregate it... it doesn't show the formula as seen below:

[DataZoe]

@Zainhashmi Can you try doing it as a new measure? Verified Total = sumx(values(table[vendor name]),[Verified])