Count for Each

[davehus]

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 🙂

[v-yulgu-msft]

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