'Dynamic Quartile Ranking - Filter with Multiple Selections
I want to display a quartile calculation from a dataset that is filtered based on a slicer selection. I have tried using a calculated column which works fine when the slicer only has 1 value selected, but when selecting multiple values the quartile column is not recalculated, and so it doesn't work. I have tried using a measure, but I can't figure out how to convert my column code to a working measure code. I have also tried using a calculated table, but again, I can't figure it out.
I have attached my workbook so you can see what I have tried so far, and explore:
https://drive.google.com/file/d/1mcQGeF1otupEZ_kRM_ShPN87ePPG1EQt/view?usp=sharing
Thank you very much in advance for your help.
Korina
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|