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

Anonymous's avatar
Anonymous
Not applicable
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