Average of Alternative state and condition

[choy]

Hi All,

Im doing the comparative analysis for alternative state A and B.

Previously , it work for Avg({A}[Value]) and Avg({B}[Value])

But now I found out there are -1 value, so I need to exclude them and do average.

I used  below syntax, while it returned the same result for A and B.

Could anyone help on this?

Avg({A}{<[Value]=-{'-1'}>} [Value])

Avg({B}{<[Value]=-{'-1'}>} [Value])

[sidhiq91]

@choy Your expression should look like below:

Sum({[StateB] <Year={"1997"}> }LineSalesAmount)

in your case,

Avg({[A]< [Value]=-{'-1'}>} [Value])

If this resolves your issue, please like and accept it as a solution.