Forum Discussion
Solved
Conditional Measures - Different Conditions
Hi everyone, I am new Power Bi learner, I am facing an issue while creating a measure such that, I am having table - "Data Dump" For countries IN, KR, CN, the meaure should reflect their respe...
Hi CrazyExcelor
Try this one:
DocCount = IF ( MAX('Data Dump'[Country]) IN { "IN", "KR", "CN" }, COUNT ( 'Data Dump'[Doc] ), DISTINCTCOUNT ( 'Data Dump'[Doc] ) )Pbix attached,
Try this.
DocCount =
IF (
'Data Dump'[Country] IN { "IN", "KR", "CN" },
COUNT ( 'Data Dump'[Sales Document] ),
DISTINCTCOUNT ( 'Data Dump'[Sales Document] )
)
Issue I am facing is, IF is not taking non measure column as a value .. it's not detecting 'Data Dump'[Country]
