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,
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,
- May I know, why you have used max here ?
