Forum Discussion

PowerMan1's avatar
PowerMan1
Frequent Visitor
3 years ago
Solved

Sum In One Measure

I have two variables and want to sum in one Measure. VAR Filter1 = { 196, 176, 137, 167, 171, 141, 160, 161 } VAR Filter2 = { 145, 121 } VAR FIlter3 = { 2065, 178, 138, 189, 148, 149, 190, 164...
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi PowerMan1 

     

    Not sure if I understand your expected result correctly. Do you want to add up the total of all sub values and show it on the subtotal row? If so, you can try the following measure:

    measure2 = SUMX ( VALUES ( 'Table'[Code] ), [your original measure] )

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi PowerMan1 

 

Not sure if I understand your expected result correctly. Do you want to add up the total of all sub values and show it on the subtotal row? If so, you can try the following measure:

measure2 = SUMX ( VALUES ( 'Table'[Code] ), [your original measure] )

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.