Percentage Table

[aguest]

Hi, I'm want to create a Grouped summary % table based on data in another table. Is this possible? So far I've got a measure which calculates the % in the same table for each area, but I want to pull this out and group it. The Table has Grade - 1-9, Count of Grade, Percentage of Grade (works as a percentage of total) I want to group grade 9-5, 9-4 etc and then show this figure as a percentage of the total. TIA Ann

[v-yuta-msft · Accepted solution]

@aguest ,

So your requirement is to achieve a new summarized table, right? You can click Modeling-> New Table using DAX function like SUMMARIZE() and ADDCOLUMNS(). For more details about how to achieve some specific result, I would suggest you to read tutorial from SQLBI:

https://www.sqlbi.com/articles/best-practices-using-summarize-and-addcolumns/

Community Support Team _ Jimmy Tao

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