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.
Dear all,
I am currently trying to create a security to avoid categories' KPI to appear on detailed values (lowest level). To do so I use ISFILTERED to detect if I am at the lowest level of Granularity or not by detecting if the is a filter on column available at this level of granularity.
Thus I have to detail each Column existing on the detailed Table. Do we have an equivalent of ISFILTERED but checking on the full detailled table.
Do you have any ideo for that.
Best
Oln
I often use HASONEVALUE for such a thing. Sometimes it might even be necessary to create a dimension table with a distinct list of values which will be linked to your fact table. I then use the dimension table as the filter condition. From here you can use HASONEVALUE on the dimension table to know if a selection has been made.
Does that cover your scenario?
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |