I currently have
| Store | LY Sales | TY Sales |
1 | $298.66 | $224.47 |
1 | $67.48 | $0 |
2 | $226.24 | ($79.99) |
2 | ($804.98) | $110 |
2 | $0 | $180 |
and so on (161 Stores total; 62,318 rows total)
I would like to have buckets for the total of each column (Top = Greater than 75 percentile; MID = between 75th and 25th; BOTTOM = Less than 25th Percentile) that I can use to filter visuals
This would allow me to compare sales,cost, inventory and gross margin between Top, Mid, and Bottom Stores based on their total sum for each column with their Percentile buckets in mind
I thought getting the percentile and then doing a custom column based on that value would get me what I want BUT
Measure = PERCENTILE.EXC(Table[LY Sales],.75) returns 204 which is a problem when each of the TOP stores in Table[LY Sales] are all $371,741.45+
Additionally I would like a card filter that shows the DistinctCount of Stores that are in each of these buckets.
