Skip to main content
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
Mt3
Contributor III
Contributor III

Alternate States discrepancy

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.

1 Reply
rubenmarin

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

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

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