Forum Discussion
Filtering visual based on calculated measure
Hi, I have the requirement to display:
1. schools who have only opted for a specific subject (Personal Project)
2. display all schools not in Graph 1 (opted for Personal project and other subjects). To identify this I have created indicators and to handle Graph 2 created a calculated measure which sums up the indicator at school level (last column below).
DAX used for the sum of Not PP Ind 1
What is returned on applying filter Sum of Not PP Ind1 is not 0
I have been struggling for the past couple of days, any help on this will be appreciated. Thanks!
1 Reply
- v-yinliw-msftCommunity Support
Hi vini_udenia ,
Seeing that you used the selectedvalue function in your formula, could you please try to add some slicers?
And then you can select the value what you want.
Hope these help you.
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.