Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have created two alternate states on the sheet, created separate measures for each state following the same schema:
COUNT({[AlternateState1]}{1<[ConditionField]={'ConditionValue'}>}[Field])
COUNT({[AlternateState2]}{1<[ConditionField]={'ConditionValue'}>}[Field])
However after applying filter for AlternateState1 no change is visible on charts. With AlternateState2 it works as desired.
Did any of you encounter similar discrepancy? What could be the rootcause? I have followed same schema with both States&Measures.
Hi, try setting the altern state instead of '1':
COUNT({[AlternateState1]<[ConditionField]={'ConditionValue'}>}[Field])
COUNT({[AlternateState2]<[ConditionField]={'ConditionValue'}>}[Field])