Forum Discussion

darko861's avatar
darko861
Resolver II
3 years ago
Solved

Filtering Matrix by slicer

Hi community,   I'm trying to filter the matrix based on a filter condition set by a slicer.     So, if I choose greater than or equal to 80% the matrix should only display the rows that a...
Need Help
  • darko861's avatar
    darko861
    3 years ago

    Hi,

     

    One way of doing it might be to create two measures like this:

     

    Rev6 = SWITCH(TRUE(),ISFILTERED(DimAccounts[Subheader])||ISFILTERED(DimAccounts[Subheader2])||ISFILTERED(DimDate[Month-Year]),[Revenue],[Revenue Display])
     
    Rev7 = SWITCH(TRUE(),ISINSCOPE(DimAccounts[Subheader])||ISINSCOPE(DimAccounts[Subheader2])||ISINSCOPE(DimDate[Month-Year]),[Revenue],[Revenue Display])
     
    Both measures give the correct results. I will use Isinscope.
    Do you think this is the most efficient way?

     

     

darko861's avatar
darko861
Resolver II
3 years ago

Hi,

 

One way of doing it might be to create two measures like this:

 

Rev6 = SWITCH(TRUE(),ISFILTERED(DimAccounts[Subheader])||ISFILTERED(DimAccounts[Subheader2])||ISFILTERED(DimDate[Month-Year]),[Revenue],[Revenue Display])
 
Rev7 = SWITCH(TRUE(),ISINSCOPE(DimAccounts[Subheader])||ISINSCOPE(DimAccounts[Subheader2])||ISINSCOPE(DimDate[Month-Year]),[Revenue],[Revenue Display])
 
Both measures give the correct results. I will use Isinscope.
Do you think this is the most efficient way?