Forum Discussion

davehus's avatar
davehus
Icon for Memorable Member rankMemorable Member
9 years ago

Count for Each

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 :)
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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