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

tex628's avatar
tex628
Community Champion
6 years ago

Try something like this for the total:

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


Br,
J

mafaber's avatar
mafaber
Helper II
6 years ago

It works, thank you all!