Forum Discussion

tamnguyenEPM's avatar
tamnguyenEPM
New Member
5 years ago
Solved

Measure in Slicer

Hello everyone, Hope you're all well.    I have a measure as below:  ID-Print = CALCULATE(count(RisksRegister[Index]),FILTER(ALLSELECTED(RisksRegister),RisksRegister[Index]<= MAX(RisksRegister[I...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi tamnguyenEPM ,

     

    You can create a new table for slicer:

     

     

    Then you can create the following visual level filter and add it to the visual you want to filter by slicer:

    measure = IF(ISFILTERED('Table'[Value]),IF([ID-Print]>= MAX('Table'[left]) &&[ID-Print] <=MAX('Table'[right]),1,0),1)

     

     

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

     

    Best Regards,

    Dedmon Dai