Bins Count

[ExcelKnut]

I created a matrix that consists of two fields (Grade & Student ID) and two measures (Student ID Count & Student ID Bins).  The Student ID Count simply counts the number of occurrences of the Student ID and the Student ID Bins assigns the Student ID to a bin based on the Student ID Count--so far so good, no issues (see 1st screenshot below).  Untimately I need a count for each bin (see 2nd screenshot below) but I don't understand why I can't create another matrix and add the Student ID Bin to Rows.  Power BI only lets me add it to Values  Any help is greatly appreciated!!!

Thanks,

Jeff

[Anonymous · Accepted solution]

Hi, @ExcelKnut 

You can try the following methods. Based on the data you provided.

Create a new table.

New table = SUMMARIZE('Table',[Student ID],"Bins",[Student ID Bins])

Result:

Is this the result you expected?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu]

could you pls provide some sample data not the matrix table