percentage for sum and average

[NISHA_S]

I have data like above for report creation.

Alraedy am calculating sum for tria and average for commission using some measures...like below

TRIA sum = CALCULATE(SUM('Sheet1'[TRIA]),'Sheet1'[ENDORSEMENT]=0 )

AVg Commission = CALCULATE (AVERAGE('Sheet1'[Commission]),FILTER('Sheet1',  'Sheet1'[ENDORSEMENT]= 0))

I want (%) percentage value for category type Percenatge of Total based on TRIA sum and AVg Commission

plse help...

[v-kelly-msft · Accepted solution]

Hi @NISHA_S,

Modify your measure as below:

TRIA sum = CALCULATE(SUM('Sheet1'[TRIA]),FILTER(ALL('Sheet1'),'Sheet1'[ENDORSEMENT]=0 &&'Sheet1'[Category]=MAX('Sheet1'[Category])&&'Sheet1'[Type]=MAX('Sheet1'[Type])))
AVg Commission = CALCULATE (AVERAGE('Sheet1'[Commission]),FILTER(ALL('Sheet1'),  'Sheet1'[ENDORSEMENT]=0&&'Sheet1'[Category]=MAX('Sheet1'[Category])&&'Sheet1'[Type]=MAX('Sheet1'[Type])))

Then create a new measure as below:

Percentage of Total=DIVIDE('Sheet1'[TRIA sum],'Sheet1'[AVg Commission])

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!