Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Anyone has any thoughts? Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |