Forum Discussion

mafaber's avatar
mafaber
Helper II
6 years ago
Solved

Different Measure Total using SUMX

Hi,   I would like to change how my measure calculates the total. For that I'm using the HASONEFILTER function and that works just fine, it correctly evaluates the first expression for each value r...
Need Help
  • tex628's avatar
    tex628
    6 years ago

    Try something like this for the total:

    Measure2 = 
SUMX(
SUMMARIZE(
'Table';
'Table'[Category];
"Value" ; [Measure]
) ;
[Value]
)


    Br,
    J

PaulDBrown's avatar
PaulDBrown
Community Champion
6 years ago

mafaber 

 

Try the following (I'm using random data):

1) the measures:

Sum of Actuals = SUM('Data Table'[Actuals])
Sum of Target = SUM('Data Table'[Target])
Actuals / Target = DIVIDE([Sum of Actuals]; [Sum of Target])
SUMX of Actuals / Target = SUMX(SUMMARIZE('Data Table'; 'Data Table'[Channel]; 
                            "Calculation"; [Actuals / Target]); 
                                [Calculation])

 

And you will get this result

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Thanks buddy, this resolved a big issue for me.