Power BI DAX expression more than 2 or conditon

Question

I am creating roles in power BI and filtering the table by principle code -

for example role1 - can only see data of CKBD , CKRANP , DA principle for that i am using dax function -

OR([principlecode] = "CKB" ||  [principlecode] = "CKBD"|| [principlecode] = "DA")

but its say or condition can have only 2 argument , there is any way of doing this ?

thanks

Answer 1

Heyyy @Hannah, you just need remove or

([principlecode] = "CKB" ||  [principlecode] = "CKBD"|| [principlecode] = "DA")

If you are interested in learning Power BI, check out the Power BI Course Curriculum now!

Also Read:

How do you resolve circular dependency errors in DAX expressions when creating calculated columns or measures?