Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 🙂
Hi @davehus,
To count the number of price points for each product, you can use DISTINCTCOUNT() function like
=Calculate(DistinctCount('Table'[Price]), AllExcept('Table','Table'[Product]))
For more advice, please provide some sample data and detailed description about your expected output so that I can reproduce your scenario.
Best regards,
Yuliana Gu
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |