DAX code to count orders with crossed categories

[jormaga]

I've got a list of units which are being sold by a shop. Each line describes date, order number, number of units and category (A and B in this example).
How can I, using just DAX measures in a pivot table, know how many orders are both in categories A and B per day? I've tried using CALCULATE in several ways, but I can't find the correct way to do it...

Here below there is a sample table

Thanks a lot!

Jorge

 

[jormaga]

If it wasn't clear through the post, let me say that the pivot table should show:

25/05/2016 3 (orders 100, 104 and 105 have units from categories A and B)
26/05/2016 1 (order 200 has units from categories A and B)


Thanks

 

[anvg]

Hi
Try with

CALCULATE(DISTINCTCOUNT('Table1'[OrderNo]),
    FILTER(
        SUMMARIZE(FILTER('Table1', 'Table1'[Category]="A" || 'Table1'[Category] = "B"),
            'Table1'[OrderNo],"categories",DISTINCTCOUNT('Table1'[Category])
        
        ),
        [categories]=2
    )
)

Regards,

 

[anvg]

Or simpler

COUNTROWS(
    FILTER(
        SUMMARIZE(FILTER('Table1', 'Table1'[Category]="A" || 'Table1'[Category] = "B"),
            'Table1'[OrderNo],"categories",DISTINCTCOUNT('Table1'[Category])
        
        ),
        [categories] = 2
    )
)