Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

slicer does not filter visual

I have 2 slicers and 2 cards here. The cards are from different tables from the slicers. But they will only change when I use the YEAR slicer, but not for the PURPOSE. What DAX should I use to make t...
Need Help
Show and Tell
Tips and Tricks
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Hi Anonymous ,

     

    If you don't want to change the relationship, you can create measures like this.

    Measure = CALCULATE(COUNT(dms[NAME]),FILTER(ALL(dms),dms[YEAR] in VALUES(cost[YEAR]) &&dms[PURPOSE] in VALUES(cost[PURPOSE])))

     

     

    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 Anonymous ,

 

If you don't want to change the relationship, you can create measures like this.

Measure = CALCULATE(COUNT(dms[NAME]),FILTER(ALL(dms),dms[YEAR] in VALUES(cost[YEAR]) &&dms[PURPOSE] in VALUES(cost[PURPOSE])))

 

 

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