Power BI: calculate the average of unique values

I have this table:

power bi

If I do an average, I got 95.76%, the point is that this calculation includes the duplicate numbers and what I want, it is to have an average of unique percentage to get 93.55%.

power bi

This is the formula:

AVERAGEX(DISTINCT(SELECTCOLUMNS(FILTER('table','table'[argument1]='table'[argument1]),"new name",[argument2])),[new name])

power bi

If I have other months and I want it per month, I will add another condition in the formula:

AVERAGEX(DISTINCT(SELECTCOLUMNS(FILTER('table','table'[argument1]='table'[argument1]),"new name1",[argument2],"new name2",[argument3])),[new name])

power bi

Based on my table, this formula may not work so alternatively, I use this one:

AVERAGEX(SUMMARIZE('table','table'[argument1],'table'[argument2]),'table'[argument2])

power bi
power bi

Interesting Management