Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have measure
SUm = SUMX(Table, [VALUE])
But have to write formula to ignore total in grandtotal if COuntry = ALL ?
Expected result
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.
User | Count |
---|---|
124 | |
106 | |
99 | |
63 | |
59 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |