Share via

Difference between Count() and CountA() function in Power BI

Anonymous
2024-10-02T09:17:10+00:00

Hi,

I am getting same result for both function where my table consists of one column having numeric,text and blank datas.

Microsoft 365 and Office | Install, redeem, activate | Other | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-10-10T21:26:02+00:00

    Hi P R ROUT,

    It's because the COUNT and COUNTA are identical in DAX for all the data types except Boolean. + info in https://dax.guide/count/

    Regards,

    Paulo_Silva

    0 comments
  2. Anonymous
    2024-10-03T02:16:28+00:00

    Hello,  P R ROUT

    Thank you for visiting Microsoft Community. 

    I wish I could handle your issue. However, since your problem is about Power BI, publishing them on corresponding forum would be better because more users post these issues there. There are experts who can provide more professional solutions in that place.  

    Here is a link to the forum where you can raise specific scenarios and share ideas that can help you solve problems:  Power BI forums - Microsoft Fabric Community.

    Sincerely hope that your question will be dealt with appropriately after contact the correct department. Thank you for your understanding! 

    Best wishes, 

    Lucia Wu - MSFT | Microsoft Community Support Specialist

    0 comments