Forum Discussion

JRock2326's avatar
JRock2326
New Member
3 years ago

Summation Help

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!

Need Help

2 Replies

  • Ahmedx's avatar
    Ahmedx
    Super User
    3 years ago

    you need to create another measure and there
    use function SUMX

    = SUMX ( 'tbl', [Valuation])

---- 'tbl' it depends what columns you have in your matrix------
  • JRock2326's avatar
    JRock2326
    New Member
    3 years ago

    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!