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:
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!
I would probably attack this with a GENERATEALL(VALUES([Hardware]),VALUES([Software])).
Proud to be a Datanaut!
Could you post your desired result if possible?