Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Hi @Anonymous,
Could you post your desired result if possible?
Regards,
Daniel He
I would probably attack this with a GENERATEALL(VALUES([Hardware]),VALUES([Software])).