Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Icon for Impactful Individual rankImpactful Individual
6 years ago
Solved

Measure dont react to slicer

Hello,

 

I have a slicer Table[Step] with the values 0,1,2,3. In the filter pane i filter 1,2,3. I also want my value for 1,2,3. So I write: 

 

= CALCULATE( DISTINCTCOUNT( Table[Value] ); Table[Step] <> 0)

 

I get the right value. But my measure dont react an more to the slicer? 🤔 

Need Help

5 Replies

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    6 years ago

    HI Pikachu-Power ,

     

    Just modify your DAX as follows:

    = CALCULATE( DISTINCTCOUNT( Table[Value] ); FILTER(ALLSELECTED(Table); Table[Step] <> 0))

     

    If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

     

    Thanks,

    Pragati

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      6 years ago

      Pikachu-Power update your measure as below

       

      CALCULATE ( 
DISTINCTCOUNT( Table[Value] ); 
KEEPFILTERS( Table[Step] <> 0) 
)

       

      I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!