Forum Discussion

Imthedan's avatar
Imthedan
Icon for Helper II rankHelper II
6 years ago

Getting count based on multiple column criteria (countifs for excel)

Hello!   I have a table that has call date, call status and identifer.   What I want to do is create a measure that will count rows based on call status and identifer. Identifer is a unique value...
Imthedan's avatar
Imthedan
Icon for Helper II rankHelper II
6 years ago

I might have just figured out a way to do it.

 

I just added  a custom column that if the LEN of the transaction ID column is greater than 1, then add value "transactionid" --

 

Then I just did:

 

Appointment = CALCULATE(COUNTROWS(Table),Table[status] = "Appointment Set",Table[trans_test] = "trans")

 

This appears to be counting correctly. I was hoping for a way that didn't involve adding new columns, but this seems to work.

 

Thank you!

vivran22's avatar
vivran22
Icon for Community Champion rankCommunity Champion
6 years ago

 

Imthedan 

I have used the DAX measure shared in the earlier response, and it is giving the desired results:

 

I am not sure why it is not working for you.

 

What you need is possible without a calculated column.

 

Cheers!
Vivek

If it helps, please mark it as a solution. Kudos would be a cherry on the top 🙂
If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)

Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter