Matrix with binned values for multiple columns

[mmandich]

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?

[Ritaf1983 · Accepted 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