SUMX by filter

[Analitika]

I have measure

SUm = SUMX(Table, [VALUE])

But have to write formula to ignore total in grandtotal if COuntry = ALL ?

Expected result

[v-lionel-msft]

Hi @Analitika ,

Please do like this.

sum = 
VAR x = SUMX( Sheet5, [Value])
VAR y = 
CALCULATE(
    SUM(Sheet5[Value]),
    FILTER(
        Sheet5,
        Sheet5[Country] = "ALL"
    )
)
RETURN
IF(
    HASONEFILTER(Sheet5[Country]),
    x,
    y
)

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.