Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a user slicer and a matrix table of values populated by a series of countrow conditions. I would like the table to be affected by the user selection but the user selection can also be blank, meaning "all".
I have tried including the selected user in the filter condition but as this appears blank when no user is selected, the filter does not bring back the correct number of rows.
Question. How can I handle a blank filter condition?
VAR CurrentUser = SELECTEDVALUE('opportunities'[_owninguser_value])
@mattbarker , you can use isfiltered to check you have got some value of not
or try like
VAR CurrentUser = values('opportunities'[_owninguser_value])
Hi @amitchandak,
Thank you. I will investigate isfiltered. You could please give me an idea of how it is used in this context?
You said "or try like" but I did not see any change to my DAX. Did you mean to recommend a change to my DAX?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
23 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
42 | |
39 | |
19 | |
19 |