Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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:
@ADSL You could always use MC Aggregations: Multi-Column Aggregations (MC Aggregations) - Microsoft Fabric Community
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
185 | |
92 | |
67 | |
62 | |
52 |