Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Could anyone help checking this measure? Appears to be correct, but it is not returning any values.
If([APSYS.Site]='D&IS UK', Avg({<[APSYS.APSYS_Sub_Item]={'Global'},
[APSYS.APSYS_Result_Level]={'Domain Level'}>}[APSYS.APSYS_Score]))
Many thanks
Jose
Incorporate all conditions inside the set
=Avg({<[APSYS.Site]={'D&IS UK'}
,[APSYS.APSYS_Sub_Item]={'Global'}
,[APSYS.APSYS_Result_Level]={'Domain Level'}>
}[APSYS.APSYS_Score])
Incorporate all conditions inside the set
=Avg({<[APSYS.Site]={'D&IS UK'}
,[APSYS.APSYS_Sub_Item]={'Global'}
,[APSYS.APSYS_Result_Level]={'Domain Level'}>
}[APSYS.APSYS_Score])
Thanks a million! Spot on!
Worked great!