Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Everyone!
It's my first post, but I expect it will not be the last one.
My problem is that i want to count the orders which have the next filters, but if the order have the three variables, I only want to count like one order.
I wrote something like this, but was wrong.
Thank you in advance!
Solved! Go to Solution.
@JoanElGran1899 , You can add any number like
Calculate( [Measure], filter(Table, Table[A1] ="A" || Table[A2] ="B" || Table[A3] ="C"))
another example
Calculate( [Measure], filter(Table, (Table[A1] ="A" || Table[A2] ="B" || Table[A3] ="C") && Table[D1] ="D"))
@JoanElGran1899 , In this one you should remove if , filter with OR(||) seems fine.
If this does not work
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@amitchandak Thank you for answer,
I tried OR before but it only accept two conditions, and I have three conditions.
@JoanElGran1899 , You can add any number like
Calculate( [Measure], filter(Table, Table[A1] ="A" || Table[A2] ="B" || Table[A3] ="C"))
another example
Calculate( [Measure], filter(Table, (Table[A1] ="A" || Table[A2] ="B" || Table[A3] ="C") && Table[D1] ="D"))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
96 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |