How to create a new percentage measure

[aggarwal25]

Hi,

I have a data set with a column 'Group by Scores' wherein tere are 3 groups. Group 1 - has responses for category A, group 2 has has responses for category B, Group 3 - has responses for category C. I am trying to create a measure to calculate % of each group. How can I do this in POwer BI.

Group 1 % = Sum of esponses for category A/Total of coulmn ''Group by Scores'

ANy help would be appreciated.

Best

Neha

[MFelix · Accepted solution]

Hi @aggarwal25,

Try this:

Group 1% =DIVIDE( CALCULATE(COUNT(Table[Group by scores]); Table[Group by scores]="Category A")); CALCULATE(COUNT(Table[Group by scores]); ALLSELECTED(Table[Group by Scores])))

The all selected formula is to consider only selected values.if you have any slicers in your report if.you want all results no.matter the slicers change to ALL.

Regards,
MFelix