Power BI DAX expression more than 2 or conditon

0 votes

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

Oct 29, 2018 in Power BI by Hannah
• 18,520 points
3,309 views

1 answer to this question.

0 votes

Heyyy @Hannah, you just need remove or

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


If you are interested in learning Power BI, then check out Power BI Online Training now!

Also Read:

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

answered Oct 29, 2018 by Kalgi
• 52,350 points

Related Questions In Power BI

0 votes
0 answers

How do you resolve memory or performance issues when running large Power BI reports with heavy DAX calculations?

How do you resolve memory or performance ...READ MORE

Oct 30, 2024 in Power BI by Evanjalin
• 28,990 points
278 views
0 votes
0 answers

How do you resolve memory or performance issues when running large Power BI reports with heavy DAX calculations?

How do you resolve memory or performance ...READ MORE

Nov 5, 2024 in Power BI by Evanjalin
• 28,990 points
168 views
0 votes
2 answers

What are the main advantages of using Copilot for Power BI users who are not experienced with DAX or M code?

Power BI Copilot helps beginners by automatically ...READ MORE

answered 4 days ago in Power BI by anonymous
• 2,230 points
131 views
0 votes
1 answer

Power BI getting 2 week back same day value

You can use DATEADD() function to compute the 14 ...READ MORE

answered Apr 5, 2019 in Power BI by Upasana
• 8,620 points
1,543 views
+3 votes
2 answers

Combine tables in Power BI

You can also achieve this using a ...READ MORE

answered Oct 5, 2018 in Power BI by lina
• 8,220 points

edited Oct 11, 2018 by Kalgi 2,731 views
0 votes
2 answers

Power BI Dax Multiple IF AND Statements

HI I have Column Patient 12 13 14 15 18 IN Patient=12, 13 Out ...READ MORE

answered May 23, 2019 in Power BI by VNK
19,240 views
0 votes
1 answer

Distinct count filtered by condition using Power BI Dax

Try this, it should work: DistinctCountActiveMonths = CALCULATE( ...READ MORE

answered Oct 5, 2018 in Power BI by Kalgi
• 52,350 points
37,955 views
0 votes
1 answer

Are 2 MM rows too much data for Power BI Online to manage?

PowerBI can easily handle 400MM rows and ...READ MORE

answered Sep 28, 2018 in Power BI by Kalgi
• 52,350 points
1,316 views
0 votes
1 answer

Power Bi Dax Table

You need to wrap the numbers in ...READ MORE

answered Oct 5, 2018 in Power BI by Kalgi
• 52,350 points
1,306 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP