Sum the values of a measure

[Miguel05]

Hi guys,

I'm struggling to create a measure to extract the following information from one grid:

https://imgur.com/a/J6nDLZ8

What is being displayed on this grid, are the values for 3 different measures. What I want to do is to create a two new measure that gives me a sum of the measure "T/O" and "Margin" when the measure "Margin %" is bigger than 11%.

I tried a lot of things, and the closer that I got was this measure with an IF statement:

https://imgur.com/SPEgUwp

The idea is to create a card visual that displays the sum of T/O and Margin, which is giving me a blank result: 
https://imgur.com/a/JJ687pV

When I try to use a grid to see if the measure is working fine, it won't give me the sum of the values calculated by my metric:
https://imgur.com/gmrspVb

Does anyone know how can I fix this? I will be much appreciated.

PS: Apologies for the links of the images instead of actual screenshots, but for some reason I weren't allowed to post the image on this post.

Thanks in advance!

[Anonymous]

HI @Miguel05,

AFAIK, measure formula calculation result is based on its row contents.
If you want to summarize the current result, you need to manually simulation its row contents and category groups in a variable table and add a new field with a measure formula to this table. After these steps, you can use iterator aggregate functions on this variable table to get correspond measure summary results.

If you confused about coding formula, please share some dummy data with dax formula and expected result to help us clarify your requirement and do test on it.

Regards,

Xiaoxin Sheng

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490