Forum Discussion

TimeaW's avatar
TimeaW
Frequent Visitor
3 years ago
Solved

static grand total in matrix when filtered

Hi,

 

I have a matrix with different countries as rows and Value (USD) as values. If I filter on a country, I want to keep the grand total unchanged. So in this case, if I filter on Zambia, I want it to show 103.55 for Zambia and 287,524.39 for Total.

 

 

 

Is it possible?

 

 

Filtering
help with matrix
static total
Total wrong in matrix
  • TimeaW's avatar
    TimeaW
    3 years ago

    I've managed to solve it with:

    Total  = if(isinscope(Data[Country]),sum(Data[USD Value]),calculate(sum(Data[USD Value]),all(Data[Country])))

4 Replies

  • Ajendra's avatar
    Ajendra
    Icon for Resolver I rankResolver I
    3 years ago

    Hi,

     

    I hope this message finds you well!

     

    Use edit Interactions to show Grand Total! 

  • TimeaW's avatar
    TimeaW
    Frequent Visitor
    3 years ago

    Hi,

     

    I tried to look there but couldn't find the option to show grand total for this visual. I can only edit interactions with other visuals.

  • TimeaW's avatar
    TimeaW
    Frequent Visitor
    3 years ago

    Can anyone help? Maybe a DAX formula with ALL? I tried but couldn't find one which worked.

     

    Thanks in advance.

  • TimeaW's avatar
    TimeaW
    Frequent Visitor
    3 years ago

    I've managed to solve it with:

    Total  = if(isinscope(Data[Country]),sum(Data[USD Value]),calculate(sum(Data[USD Value]),all(Data[Country])))