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.

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey Anonymous ,

 

in the overall measure you have to exclude the slicers for Store and Division. Try the following approach:

My Overall Measure =
CALCULATE(
    SUM( myTable[Overall] ),
    ALL( StoreTable[Store] ),
    ALL( DivisionTable[Division] )
)

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis