I have a dataset like this:
I would like to create a table or a matrix in order to have the score of each category (as if the sum of each name within them is 100%) like this:
with the score of the category 1 is 7.2 = 5*30%/(30%+35%) + 9*35%/(30%+35%)
Go to Solution.
@BMltc , if this option can work, you do not need additional measures. This will show subtotal too as you have more than one column in the row.
View solution in original post
thanks @amitchandak , so I need to create an additionnal column just for the score of each subgroup?
@BMltc , In a matrix you can right on the measure in visual pane and use % of total or % of sub total
or try measures like
Percent of sub Toal = divide([score], calculate([score], allselected(Table, Table[categorty] =max(Table[category]))))
Percent of Toal = divide([score], calculate([score], allselected(Table)))
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!