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 All,
I have created a DAX with Switch function so that score value gets changed as per standard selected in slicer. I have also used isblank to manage blank error.
There is a case where a one school don't have one standard applciable i.e. School12 don't have standard 4A applicable. When I select School12 in first slicer & standard 4A in second slicer, I should get value as N/A as I have created a measure that if the value is blank, sho it as N/A. But I am getting error as Blank. How can I fix this?
Table1
Column1- Name of School
Column2- Standard
Column3- Subject
Column4- Score
I have two slicers on the dashboard-
1) Name of the school from Table 1
2) Standard from Table 1
Hi @harshadrokade ,
According to your description, I create a sample, when I select “4A” in the first slicer, as its subject is not “ABC4”,the measure shows “N/A”, and the second slicer of school only display schools which standard is “4A”.
Is your method different from mine? Or can you explain more about your sample?
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
When you select School12 from the first slicer, that should remove 4A from the second slicer, so how have you got this set up?
Also, without your data it's very hard to recreate data that matches what you have and therefore be able to test things.
Can you please supply some sample data and explain how your slicers/model are set up. It would be better if you can supply your PBIX with anonymised data.
Regards
Phil
Proud to be a Super User!
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |