Forum Discussion
Slicer
- 2 years ago
Anonymous , Create an independent/disconnected table for location. And then create measures like
calculate([Your measure], filter(Table, Table[Location] in Values(Location[Location]) || Table[Location]= "NA") )
Need of an Independent/disconnected Table in Power BI - Exclude: https://youtu.be/lOEW-YUrAbE
- Anonymous2 years ago
Hi Anonymous
Based on the solution amitchandak provided, if you don't have measure, you can try the modify it to the following
Measure = IF ( SELECTEDVALUE ( Table[Location] ) IN VALUES ( Location[Location] ) || SELECTEDVALUE ( Table[Location] ) = "NA", 1, 0 )Then put it to the visual filter.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous , Create an independent/disconnected table for location. And then create measures like
calculate([Your measure], filter(Table, Table[Location] in Values(Location[Location]) || Table[Location]= "NA") )
Need of an Independent/disconnected Table in Power BI - Exclude: https://youtu.be/lOEW-YUrAbE