DAX - Powerpivot - Binning / Banding HELP (Doing group Selection on regular Pivot)

[Anonymous]

Hi, all.

I am looking for a DAX approach on binning; it's so easy to do binning on regular pivot tables, but it takes a bit more effort in power pivot (Excel)

I was following up what was suggested in this post but did not work for me https://social.msdn.microsoft.com/Forums/Lync/en-US/fc40d3b2-9ae1-4e23-8d4d-17faddea8405/help-with-c...

DAX:

CustomersByBin:= SUMX(Bin; COUNTROWS(FILTER(Customer;[TotalAmountPaid]>Bin[Lower] && [TotalAmountPaid]<=Bin[Upper])))

It is the same case essentially - I am looking for counting rows based on bins - this is expected outcome

this is the helper table.

and it is about counting instances of another measure.

Any help is appreciated. Thanks!

[Anonymous]

Anyone has any thoughts? Thanks!