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,
Our company sells products a different prices dependant on the sector we trade in. How do I count the number of price points for each product we sell?
Thanks 🙂
Solved! Go to Solution.
Based on your description, you want to count number of prices group on Product level. Right?
In this scenario, you can use ALLEXCEPT() in to calculation to ignore all other filter but Prodct.
Count Of Prices per Product = CALCULATE(DISTINCTCOUNT('Product'[Price]),ALLEXCEPT('Product','Product'[Product]))
Regards,
Based on your description, you want to count number of prices group on Product level. Right?
In this scenario, you can use ALLEXCEPT() in to calculation to ignore all other filter but Prodct.
Count Of Prices per Product = CALCULATE(DISTINCTCOUNT('Product'[Price]),ALLEXCEPT('Product','Product'[Product]))
Regards,
Suppose there is 'Prices' table (Product-Sector-Price) and 'Products' table (other Products info).
They should be linked 1 to many (Products-Prices)
Calculated column in 'Products' table:
Number of different prices per product = CALCULATE(DISTINCTCOUNT('Prices'[Price]))
If you need a measure which will count number of different prices per selected product (or group of products), the formula is the same
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |