Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Remove filter for Specific Measure or field

Hi,   I have a Visual like below, Whenever the Select Store and Division will filter out -Table column Store and Division only need to filter and Overall need not to be filter. Overall Fields need...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Based on my test, you need to create a new table for slicer like this:

    ForSlicer = DISTINCT(SELECTCOLUMNS('Table',"Select Store",[Store],"Division",[Division]))

    Then create a flag measure (when values matched , set as 1):

    Flag = IF(MAX('Table'[Store]) in ALLSELECTED('ForSlicer'[Select Store]) && MAX('Table'[Division])in ALLSELECTED('ForSlicer'[Division]) ,1)

    Now could find the matched row according to the flag measure:

    Store Measure = CALCULATE(MAX('Table'[Store]),FILTER('Table',[Flag]=1))
    Division Measure = CALCULATE(MAX('Table'[Division]),FILTER('Table',[Flag]=1))

    The final output is shown below:

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

Based on my test, you need to create a new table for slicer like this:

ForSlicer = DISTINCT(SELECTCOLUMNS('Table',"Select Store",[Store],"Division",[Division]))

Then create a flag measure (when values matched , set as 1):

Flag = IF(MAX('Table'[Store]) in ALLSELECTED('ForSlicer'[Select Store]) && MAX('Table'[Division])in ALLSELECTED('ForSlicer'[Division]) ,1)

Now could find the matched row according to the flag measure:

Store Measure = CALCULATE(MAX('Table'[Store]),FILTER('Table',[Flag]=1))
Division Measure = CALCULATE(MAX('Table'[Division]),FILTER('Table',[Flag]=1))

The final output is shown below:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.