Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

display measure as a value

hi all

i have a measure that counts the amount of entries based on a filter

Total Incidents = CALCULATE(DISTINCTCOUNT(TblEventTracker[EventTracker_ID]), FILTER(TblEventTracker,[EventType_IDFK]=1))

how can i use this in a slicer so i can display it as a value?

AnkitKukreja
5 years ago
Hi Anonymous
To use you're measure as a slicer, you have to create a new table to use it as a slicer.
Please follow the video for better understanding.
https://www.youtube.com/watch?v=AZAL-QPn5Zc

Please mark it as a solution, if it answers your question.

Thanks and Regards,
Ankit
www.linkedin.com/in/ankit-kukreja1904

3 Replies

mahoneypat
Microsoft Employee
5 years ago
Not sure I understand your scenario. Have you tried just putting your measure in a Card visual? Please clarify if you are looking for more than that.

Pat
AnkitKukreja
Super User
5 years ago
Hi Anonymous
To use you're measure as a slicer, you have to create a new table to use it as a slicer.
Please follow the video for better understanding.
https://www.youtube.com/watch?v=AZAL-QPn5Zc

Please mark it as a solution, if it answers your question.

Thanks and Regards,
Ankit
www.linkedin.com/in/ankit-kukreja1904
Anonymous
Not applicable
5 years ago
Anonymous

You cannot put measure as a slicer since it does not have static values to be selected. You can create a column use the same dax formulas to be used as a slicer.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.