Set Analysis Condtional

[#1]

I have the following formula:

=Avg({1<TubeType=P(TubeType)>}[Total Usage]) I need to add another condition that includes only data where Flag=0, does anyone have an ideas?

[#2]

Hi Zeth, I think that a solution may be:

=Avg( {< TubeType={"TubeType"} , Flag={"0"} >} [Total Usage])

I hope that it help you

Regards

Agustín

[#3 · Accepted solution]

The following is the solution that acutally worked, thanks for the idea though it helped me solved the issue!

=Avg({1<TubeType=P(TubeType),Flag={'0'}>}[Total Usage])