Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello All,
I am working on terminations and my measures are not changing at all when I select a slicer option. I am looking between Voluntary and Involuntary Turnover counts. My two formulas are below for each measure that I have on a card. I added a slicer from the same Termination Type column as what is used in the formulas below. Whene I select voluntary or involuntary, neither card changes. They both just keep the exact same count. I have no other filters on the page set so I am lost. I feel like this may be a simple fix but for whatever reason, I cannot seem to figure it out.
Hi @Ryanb2412,
You can try modifying your measures as follows:
Thanks, that works! Could you please tell me why the FILTER(ALL SELECTED...) portion is necessary/what it does exactly?
Also, before making that change to the formula, I had a line graph mapping the % of workforce by quarter that worked correctly. Now it just gives me a straight line with the same cumulative value for all 4 quarters. For instance, Q1 would be 5% Q2 would be 12%. The Total for all 4 is 25% so instead of having 5% for q1, it just shows a straight line at 25% for all 4 quarters. Is there something that should be changed in the forumla to fix that?
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
108 | |
96 | |
95 | |
74 | |
71 |