This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is now in read-only for platform upgrade. Learn more
Hi
I am new to PowerBI, I have a table in below and would like to pivot it with a subtotal by type. I have created a measure, If I want to pivot the table by SKU how can I archive the result I want?
First Class Total = VAR ClassData= SUMMARIZE(FILTER(NEWTable,NEWTable[Type] = "First Class"),NEWTable[Outlet],"Total",SUM(NEWTable[value])) RETURN SUMX(ClassData,[Total])
NEWTable
| Outlet | Transaction_Date | Type | Product | value |
| LOLOMAYA | 21/3/2019 | First Class | SKU A | 1 |
| LOLOMAYA | 21/3/2019 | First Class | SKU B | 1 |
| LOLOMAYA | 21/3/2019 | First Class | SKU C | 0 |
| LOLOMAYA | 21/3/2019 | Second Class | SKU D | 1 |
| LOLOMAYA | 21/3/2019 | Second Class | SKU E | 1 |
| LOLOMAYA | 21/3/2019 | Second Class | SKU F | 1 |
| LULULALA | 21/3/2019 | First Class | SKU A | 0 |
| LULULALA | 21/3/2019 | First Class | SKU B | 0 |
| LULULALA | 21/3/2019 | First Class | SKU C | 1 |
| LULULALA | 21/3/2019 | Second Class | SKU D | 0 |
| LULULALA | 21/3/2019 | Second Class | SKU E | 0 |
| LULULALA | 21/3/2019 | Second Class | SKU F | 0 |
Result
| Transaction_Date | Outlet | Total First Class | SKU A | SKU B | SKU C | Total Second Class | SKU D | SKU E | SKU F |
| 21/3/2019 | LOLOMAYA | 2 | 1 | 1 | 0 | 3 | 1 | 1 | 1 |
| 21/3/2019 | LULULALA | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |