cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
timothyladd New Member
New Member

Count If Based on Multiple Column Criteria

What I am looking at are rows of sales orders with various hardware options and software options. Each option shows up as it's own line item. So the sales order numbers will repeat for each product included in that order. 

What I want to do is count for each unqiue combination of a hardware (found in one column) and software (found in another column). The Excel would look somethign like COUNTIF(and(HW1, SW1) with another column COUNTIF(and(HW1, SW2), etc.

Basics of what I am looking at:

example.PNG

I've tried doing a calculate with filter and it seems not to work and frankly I don't know much about DAX stuff.

Any help would be apprecited. Thanks!

2 REPLIES 2
Super User
Super User

Re: Count If Based on Multiple Column Criteria

I would probably attack this with a GENERATEALL(VALUES([Hardware]),VALUES([Software])).


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Community Support Team
Community Support Team

Re: Count If Based on Multiple Column Criteria

Hi @timothyladd,

Could you post your desired result if possible?

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.