Distinct Count for Multiple Column

[ADSL]

Hi BI Community Team,

I have a sales order table that contain customer & SKU code. To apply the distinct count of 02 these columns, I need to create the new column and merging it together to "Sales Order'[CUST & SKU]".

After that, I applied this measure: 

DistCnt = CALCULATE(DISTINCTCOUNT('Sales Order'[CUST & SKU]), 'Sales Order'[Type1] = "A", 'Sales Order'[Type2] = "B")

Any suggestion/advise to apply the measure above without mering column?

Thanks and Regards,

[Greg_Deckler]

@ADSL You could always use MC Aggregations: Multi-Column Aggregations (MC Aggregations) - Microsoft Fabric Community