Forum Discussion
Bins Count
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
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.
2 Replies
could you pls provide some sample data not the matrix table
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.
