Summation Help

[JRock2326]

Hello,

I'm having some trouble getting the proper total on my table visualization.

My measure is below:

I would like my table to show the simple_valuation except in a few specific scenarios (in which case I would like it to show contributions). My visual is showing the correct data but I can't figure out a way to SUMX it all properly.

 

Thanks for taking a look!

[JRock2326]

Thanks Ahmedx. I wasn't able to figure out the measure. Instead, I found a less elegant solution: I did the comparrision part of the measure (the "valuation" variable) in SQL and created a view to bring into PowerBI.

Thanks again!

[Ahmedx]

you need to create another measure and there
use function SUMX

= SUMX ( 'tbl', [Valuation])

---- 'tbl' it depends what columns you have in your matrix------