Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Impactful 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[S...
Need Help
  • Pikachu-Power's avatar
    Pikachu-Power
    6 years ago

    Thank you both 😊

Pragati11's avatar
Pragati11
Super 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
Super 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!