Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

CountIf in PB

Hello, i have a database just like this one in Excel In this situation i can use COUNTIF in the OrderId column, but in power bi i cant figure out how to translate this to a calculate funti...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

    According to my understanding, you want to calculate the count per OrderID, right?

     

    You could use the following formula:

    CountPerOrderId =
CALCULATE ( COUNTROWS ( 'CountIf' ), ALLEXCEPT ( CountIf, CountIf[OrderId] ) )

    My visualization looks like this:

     

    For more useful information ,you could refer to:  https://goodly.co.in/countif-power-bi-dax/ 

     

    Is the result what you want? If you have any questions, please upload some data samples and expected output.

    Please do mask sensitive data before uploading.

     

    Best Regards,

    Eyelyn Qin