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.
Hi
I have a parameted that switches the left column of a table to cycle through D&I elements.
Each of the D&I elemtnes (Age / Gender / Ethnicity etc) have "Not Captured" - This is the bulk so charts etc do not look good so I want to exclude them - If in the visual filters I exclude for each category I lose most data i.e where someone has answered on but not another they are completely excluded.
I wanted to do a measure like the following but as I cant get it to work for the life of me - Any help appreciated:
_INC/EXC =
switch
(
true(),
and(selectedvalue([parameter]) = "Gender", [Gender] = "Not Disclosed"),"Exc",
and(selectedvalue([parameter]) = "Nationality", [Nationality] = "Not Disclosed"),"Exc",
... ,
... ,
"Inc"
)
Solved! Go to Solution.
Hi,
Please kudo and accept the solution if it helps:)
Hi.
Thanks for your reply
The problem was that as I was using a parameter as the driver and each category in the parameter had its own "Not Disclosed" I eneded up doing a long measure and adding this measure to the table and filtered the measure on "Inc" then removed the measure fomr the table... It gave me a headache but I got there
Hi,
Please kudo and accept the solution if it helps:)
Looks cleaner than the solution I managed - Thankyou
I belive you could just unselect blank values from the filter pane.
Have you tried this for each of the categories?
Let me know if this works, if not I'll have a further look. Thanks and good luck! 🙂
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 |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |