Forum Discussion
Table Visual Filter
- 4 years ago
Anonymous ,
No need to show real data, you can always create some short dummy dataset to illustrate your issue.
Anyway, it is always better to provide
1. Sample (dummy dataset) data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1 to 2.It will increase your chances to get an answer as no one wants to retype your data from an image.
For your case, if I understood you correctly, you can try this measure and use it as a filter on the visual (showElm is 1):
showElm = SWITCH ( TRUE (), SELECTEDVALUE ( T[Course] ) = "a" && SELECTEDVALUE ( T[Complete] ) = "no", 1, SELECTEDVALUE ( T[Course] ) = "b" && SELECTEDVALUE ( T[Complete] ) = "no" && SELECTEDVALUE ( T[Mgr] ) = "yes", 1, 0 )If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.
Hi Anonymous ,
As a general advise, please, provide:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1 to 2.
How to Get Your Question Answered Quickly
If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.