Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
is it possible to reference a filter using a DAX formula?
e.g. IF (Filter = "Selcet All",1,2)
Thanks for your help
Solved! Go to Solution.
Hi @Anonymous
You can do something like this, where you are comparing the total number of items in the column used to the number selected in the filter:
IF ( COUNTROWS ( DISTINCT ( FilterTable[FilterColumn] ) ) = COUNTROWS ( ALL ( FilterTable[FilterColumn] ) ), 1, 2 )
Please mark the question solved when we get to the solution and consider kudoing if posts are helpful.
Cheers
Hi @Anonymous
You can do something like this, where you are comparing the total number of items in the column used to the number selected in the filter:
IF ( COUNTROWS ( DISTINCT ( FilterTable[FilterColumn] ) ) = COUNTROWS ( ALL ( FilterTable[FilterColumn] ) ), 1, 2 )
Please mark the question solved when we get to the solution and consider kudoing if posts are helpful.
Cheers
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |