PERCENTILE.EXC Bins based on columns

Marticar001 — Mon, 12 Jul 2021 00:23:30 GMT

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.

Re: PERCENTILE.EXC Bins based on columns

lbendlin — Mon, 09 Aug 2021 01:32:29 GMT

you cannot create custom columns from measures. You can only create columns from other columns.

Your sample data is not sufficient to work on a proposal.

topic Re: PERCENTILE.EXC Bins based on columns in DAX Commands and Tips

PERCENTILE.EXC Bins based on columns

Re: PERCENTILE.EXC Bins based on columns