Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I'm looking to create a matrix with counts based on how many values are in a bin.
My table has a list of sites. For each site, there are 10 or so attribute columns with a value between zero and ten (only the first attribute pictured below). For each attribute I've used a conditional column make custom bins (third column of graphics)
So for each attribute, there will be X sites in the 5 to 7.5 bin, Y in the 7.5 to 10 bin, etc.
I'd like to make a matrix like this -
Bin Attribute 1 Attribute 2 Attribute 2
0-2.5 site count
2.5-5 site count
5-7.5 site count
7.5-10 site count
So far have not been successful. How do i do this/is it possible?
Solved! Go to Solution.
Hi @mmandich
If I understand you correctly, please refer to the linked discussion:
https://community.fabric.microsoft.com/t5/Desktop/Count-and-sum-by-creating-groups-bins-filtered-on-...
If not,
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hi @mmandich
If I understand you correctly, please refer to the linked discussion:
https://community.fabric.microsoft.com/t5/Desktop/Count-and-sum-by-creating-groups-bins-filtered-on-...
If not,
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
User | Count |
---|---|
93 | |
83 | |
77 | |
74 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |