Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to make a static column for the table?

Hello! I have a slicer with the region names and table which sums up data from regions. Now, I want to make it in such a way that if the slicer selected, then only the Region column values cha...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    Anonymous 

    Please see the attachment. Hope it is helpful.

Shishir22's avatar
Shishir22
Icon for Solution Sage rankSolution Sage
5 years ago

Hello Anonymous,

 

Can you please try using measure with ALLEXCEPT?

Something like-

 

Country= Calculate(Sum(table[values] ), allexcept(table, table[region])

 

Thanks! 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Shishir22 what if I have to columns: one for country and another is regions with values?