Forum Discussion
brickanalyst
Resolver I
Resolver IHow to count rows depending on a measure
Hello there, I'd like to explain what i'm actually working on so it would be easier to find the solution I believe. I have scenarios and there are two quotes red team and yellow team. Each scen...
Hi brickanalyst
please try
measure_test =
SUMX (
DISTINCT ( 'Appended_Table'[scenario_id] ),
INT ( [avg variance between A & B] > 0.10 )
)
brickanalystResolver I
Resolver IHi tamerj1
Can you explain a little bit how it works?
Thanks / Tesekkurler.
tamerj1
Community Champion
Community ChampionSUMX iterates each scenario available in the current filter context (in the total cell for example, the scenarios available are the scenarios defined by the outer filter context), and evalute if the measure is > 0.1
INT converts TRUE to 1 and FALSE to 0
SUMX will act as a counter adding 1 for each true iteration thus counting the scenarios that fulfill the condition.
- brickanalyst
tamerj1 Thank you !