Need help with banding in Dax

Anonymous — Fri, 31 May 2019 12:13:07 GMT

Hi community,

I am trying to count a dimesnion value with some banding For e.g. I want to see how many customers (dimension) fall in a specfic banding. I have made my bands for e.g. 0-10,11-20, 21-50, 51-100,101-1000 and >=1001 using the following dax which works fine:

Banding =

SWITCH (

TRUE ();

[Accept + Decline] >= 0

&& [Accept + Decline] <= 10; "0 to 10";

[Accept + Decline] >= 11

&& [Accept + Decline] <= 20; "11 to 20";

[Accept + Decline] >= 21

&& [Accept + Decline] <= 50; "21 to 50";

[Accept + Decline] >= 51

&& [Accept + Decline] <= 100; "51 to 100";

[Accept + Decline] >= 101

&& [Accept + Decline] <= 1000; "101 to 1000";

[Accept + Decline] >= 1001; ">=1001"

)

The issue is the dimension which i want to count to group it with the banding but it does not seem to be working. When i try to count the dimension, it aggregates the values to one count instead of grouping the value into several bands. I have attached the issue that i am facing. It gives the last value of banding and one aggregated count of customers. Please can you adivse?

Re: Need help with banding in Dax

parry2k — Fri, 31 May 2019 14:30:25 GMT

Anonymous [Accept + Decline] is a column or measure?

Re: Need help with banding in Dax

Anonymous — Sat, 01 Jun 2019 12:34:52 GMT

parry2k Accept + Decline is a measure.

Re: Need help with banding in Dax

Anonymous — Mon, 03 Jun 2019 06:43:27 GMT

parry2k [Accept + Decline] is a measure.

topic Re: Need help with banding in Dax in DAX Commands and Tips

Need help with banding in Dax

Re: Need help with banding in Dax

Re: Need help with banding in Dax

Re: Need help with banding in Dax