Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Guys, I have this measure within a KPI, how do I make the KPI change only if I select the specific filters of Month and Year?
I didn't find the "Display Condition" option to apply a "GetSelect".
Guys I found an answer to make the object ignore a specific filter.
Use this expression:
Avg({<Field=>}[MEASURE/FIELD])
Try
Avg({1<[Aderencia Geral]={">0"}, Year=P(Year), Month =P(Month)>} [Aderencia Geral])
Try this:-
Count({1<Month={"$(=Concat(Distinct Month,'","'))"},Year={"$(=Concat(Distinct Year,'","'))"}>}[Aderencia Geral])
Guys I found an answer to make the object ignore a specific filter.
Use this expression:
Avg({<Field=>}[MEASURE/FIELD])