Forum Discussion

Dhruvin's avatar
Dhruvin
Icon for Helper III rankHelper III
7 years ago
Solved

How to Calculate Count by One Column with where condition of another column in Power BI?

I have one table with following columns:  User ID  Transaction Originator  document Number   I want to calculate following measures:   Document Count by Transaction Originator =  I want Doc...
Need Help
Show and Tell
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Dhruvin

    You could use this formula as below:

    document Count by Transaction Originator = CALCULATE(COUNTA('Table'[document Number]),ALL('Table'[User ID]),'Table'[Transaction Originator] in VALUES('Table'[User ID]))+0

     

    Best Regards,

    Lin

     

     

     

     

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, Dhruvin

You could use this formula as below:

document Count by Transaction Originator = CALCULATE(COUNTA('Table'[document Number]),ALL('Table'[User ID]),'Table'[Transaction Originator] in VALUES('Table'[User ID]))+0

 

Best Regards,

Lin

 

 

 

 

Dhruvin's avatar
Dhruvin
Icon for Helper III rankHelper III
7 years ago

v-lili6-msft - Thanks a lot. That's what I'm looking for. Big thanks to you.