Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a table showing individuals' performance vs. plan as well as YoY performance for a couple prior years. These are tied to regions and another visual above. When I include only current year data, the geographical filter works and sorts only to those tied to the particular region. However, the inclusion of prior years shows a -100% growth rate and therefore includes everyone, regardless of region selected. Is there a way to tweak my measures or somehow apply a filter to only show those with data in the current year? In the first photo below, no particular region is selected. When I select the region tied to Brennan, I'd like Jackson and Heidemarie to be hidden. Does that make sense, and if so, is it possible? It's something with the YoY growth rates populating for everyone in all periods but I can't figure out how to get the measure to not show the -100% at all times.
Solved! Go to Solution.
Disregard. I was able to put an IF statement around my calc and return BLANK() if my prior years = 0. Filtering seems to be working now.
Disregard. I was able to put an IF statement around my calc and return BLANK() if my prior years = 0. Filtering seems to be working now.
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |