Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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])
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
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])