How calculate with DAX for average in multiple filter

[sugara01]

I have report above, if filter only 1 month the value is correct, but if filter for multiple month the value for percentage should be average not sum, so how the DAX formula to solve my problem?

[sugara01 · Accepted solution]

Hi I got the solution and solved my problem 😁

AVG SUM =

CALCULATE(

        if(

            SELECTEDVALUE(KPI1[UoM])="%",

            AVERAGE(KPI1[Value]),

            SUM(KPI1[Value])

            ),

            KEEPFILTERS(KPI1)

        )

[sugara01]

This is my table for your reference, guys. Really needs your help