Forum Discussion

HobbyS's avatar
HobbyS
Regular Visitor
3 years ago

Group Total on Specific Row

I have to following Table:   and the Following Dax-Code for myMeasure: =CALCULATE(SUM(Tabelle1[Amount]); ALL(Tabelle1[Currency]))   I would like to have the total of all Currencies (...
HobbyS's avatar
HobbyS
Regular Visitor
3 years ago

I have a solution:

=IF( HASONEFILTER ( Tabelle1[Currency] ); VAR _value = MAX(Tabelle1[Currency])
RETURN
IF(
    _value = "CHF";
    -CALCULATE(SUM(Tabelle1[Amount]); ALL(Tabelle1[Currency]));
    0
);-SUM(Tabelle1[Amount]))

So only if I have a Filter on Currency, the calculate-Formula is used. Otherwiese we are using total Amount (on Groups). Thank you FreemanZ  and Anonymous .