Forum Discussion

davehus's avatar
davehus
Memorable 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

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft 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