Forum Discussion

WishAskedSooner's avatar
WishAskedSooner
Continued Contributor
1 year ago
Solved

Slicer Filter Misbehaving

Hi Experts!   I have a report with several slicers. Call them A, B, C, D, and E. I have a MEASURE that returns a value based on the user selections of slicers A thru E. Call this [MyMeasure].   I...
Need Help
  • WishAskedSooner's avatar
    WishAskedSooner
    1 year ago

    Hi ajaybabuinturi,

     

    Thank you so much for your quick reply! I tried using the above, but all it did was filter out every value for some reason.

     

    But your suggestion gave me some ideas. I need to go through my Report more carefully and check the filter interactions. That is probably my problem.

  • WishAskedSooner's avatar
    WishAskedSooner
    1 year ago

    Sorry for the late response. It turns out my interactions were the problem. Once I went through each one I was able to resolve the error.

     

    Regrettably, my report is dizzyingly complex. But, I am happy to report that it is working properly now.

ajaybabuinturi's avatar
ajaybabuinturi
Super User
1 year ago

Hi WishAskedSooner,
Could you please try with below DAX 

FilterVals =
VAR _Val = CALCULATE([MyMeasure], REMOVEFILTERS('dimSlicerTable'))
Var Result = IF('dimSlicerTable'[Slicer_F_Values] < _Val, 1, 0)
RETURN
Result

 

Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.

  • WishAskedSooner's avatar
    WishAskedSooner
    Continued Contributor
    1 year ago

    Hi ajaybabuinturi,

     

    Thank you so much for your quick reply! I tried using the above, but all it did was filter out every value for some reason.

     

    But your suggestion gave me some ideas. I need to go through my Report more carefully and check the filter interactions. That is probably my problem.