For Total - get the average of Percentage instead of Sum

[Anonymous]

Hi,
For Total - get the average of Percentage instead of Sum.

By default it is calculating sum - I want to get average in of percentage in total - "38%".
Can someone please help me with the dax?

Thank you in advance

[Jihwan_Kim · Accepted solution]

Hi, please check the below picture and the attached pbix file.

Percentage expected result: =

IF (

HASONEFILTER ( Data[Category] ),

SUM ( Data[percentage] ),

AVERAGE ( Data[percentage] )

)