Alternate States discrepancy

Mt3 — Fri, 21 Jan 2022 10:03:41 GMT

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.

Re: Alternate States discrepancy

rubenmarin — Sat, 22 Jan 2022 16:44:18 GMT

Hi, try setting the altern state instead of '1':

COUNT({[AlternateState1]<[ConditionField]={'ConditionValue'}>}[Field])

COUNT({[AlternateState2]<[ConditionField]={'ConditionValue'}>}[Field])