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,
I'm somewhat new with DAX and am having an issue with creating a measure (it is probably easy but it is eluding me).
I'm creating a measure that will count the product codes in a column but I want it counted only for 5 of the many values.
So, for example, I've tried:
Product Count = Calculate(CountA (Product[type] ), Product[type]=10, Product[type]=12, Product[type]=14 ......
This works for the first product type but when I add the additional filters (12,14, etc) the result is blank. I'm assuming this is acting as an AND or it is looking for diffternt Columns to filter on. At any rate, what I'm doing is obviously wrong. I've tried other variations but I'm not finding a solution.
Any help would be appreciated!
Solved! Go to Solution.
Hi.
Use || (OR)
Product Count = Calculate(CountA (Product[type] ), Filter(Product[Type],Product[type]=10 || Product[type]=12 || Product[type]=14 ))
Hi.
Use || (OR)
Product Count = Calculate(CountA (Product[type] ), Filter(Product[Type],Product[type]=10 || Product[type]=12 || Product[type]=14 ))
Worked! Thank you!
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |