Forum Discussion
NISH72
6 years agoHelper IV
Dax for multiple (and,or) statement
Hi can someone suggest dax for the following statement Sales value < 90 and either 3+ sales rating AND 4+ salesman OR 5+ sales rating AND 1+ salesman Actually I wanted to add a filter in power bi ...
- 6 years ago
Sales value < 90 and either 3+ sales rating AND 4+ salesman OR 5+ sales rating AND 1+ salesman If(Sales value <90 && sales rating >=3 && salesman >=4 || Sales value <90 && sales rating >=5 && salesman >=1,1,0)Hi NISH72 ,
If I understand what you are looking for you can use && and || .
https://docs.microsoft.com/en-us/dax/dax-operator-reference
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel - 6 years ago
You could do it with a FILTER like:
VAR __table = FILTER( Sales value < 90 && ( Sales rating >= 3 && Salesman >= 4 || Sales rating >= 5 && Salesman >= 1 ) )
NISH72
6 years agoHelper IV
Thank you for your reply. After I use this dax the sales rating and salesman fields are still showing below 3 values even though sales values is showing correct i.e below 90
Nathaniel_C
6 years agoCommunity Champion
Hi NISH72 ,
Please read this post to get your question answered more quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Please provide us with a pbix, or a table to show us what you are doing.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel