Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I'm currently using two data sets that I've created a relationship table for further analysis. But I was struggling that when the end user filters on a specific department all the options in the job category to them.
In the below example, if the end user filters on Tax he / she shall only see PSS , CSS only and not the 3 options as per the below. Is there a way to restrict all list from appearing when I filter on a specific department?
@Rania_Ibrahim , if there table are joined to each other or have common fact. Create a meausre on many side table
say
countrows(Table)
and use that in the visual level filter and check for nonblank
https://www.youtube.com/watch?v=cyOquvfhzNM
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |