Calculate Average of Percentage in Total

[Anonymous]

Hi 

Can someone please help me with the Dax ?
Dataset - 

Calculate - 
N - Sum of Value where Color is "Red"
D - Sum of Value where Color is "Yellow"
Div - N/D
 

N = CALCULATE(SUM(Sheet1[Column3]),FILTER(Sheet1, Sheet1[Color] = "Red"))

D = CALCULATE(SUM(Sheet1[Column3]),FILTER(Sheet1, Sheet1[Color] <> "Red"))

Div = DIVIDE([N],[D])

The highlighted percentage in yellow needs to be the average of above percentages - it should show 89%. Can someone please help me with the DAX?
Thanks in advance

[VahidDM · Accepted solution]

Hi @Anonymous 

Try this:

Div =
IF (
    HASONEVALUE ( Sheet1[Category] ),
    DIVIDE ( [N], [D] ),
    AVERAGEX (
        SUMMARIZE ( Sheet1, Sheet1[Category], "DD", DIVIDE ( [N], [D] ) ),
        [DD]
    )
)

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/