Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
5 years ago

ALL from ALLSELECTED

How to filter ALL values from ALLSELECTED items?

 

I used filter in slicer and count with measure Allselected, it is ok, i got ALLselected Total 

but now in matrix i need to select multiple items and show all matrix Total (previous Allselected Total)

 

 

https://file.io/UpPvB18ZWcrN

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    5 years ago

    Hi Analitika ,

     

    Try REMOVEFILTERS .
    REMOVEFILTERS is like ALL, but it can only be used as a filter argument in CALCULATE. 


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

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    5 years ago

    Hi Analitika ,

     

    According to my test, the filtering behavior of visual interaction takes precedence over slicer, so it is suggested that you disable the interaction between visuals.

     


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

    • Analitika's avatar
      Analitika
      Post Prodigy
      5 years ago

      V-lianl-msftinteraction  cant be disabled as measure used to display chart lines, so need disable it only by formula in measure