Need help with banding in Dax

[Anonymous]

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?

[parry2k]

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

[Anonymous]

@parry2k [Accept + Decline] is a measure.

[Anonymous]

@parry2k Accept + Decline is a measure.