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,
CrazyExcelor , Try like
DocCount = CALCULATE(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]
