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

Thank you for your reply. I adjusted the measure like this:

 

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

 

Because if currency <> CHF I want to have 0. The solution is almost perfect, but de Group Total does not show. (should also be 700):

Do you also have a solution for this?

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Try using ISINSCOPE function across the group total to obtain the same requirement.

  • HobbyS's avatar
    HobbyS
    Regular Visitor
    3 years ago

    The ISINSCOPE function is not available in my Power Pivot installation...