The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Greetings all,
I'm new to Power BI/Dax in general so apologize if this might seems obvious but I couldn't manage to find a way to do it.
I basically have a dimension category here I need to sum AA & BB then CC & DD. And create a final table B
TABLE A: DETAILS | ||
Category | Value | |
AA | 10 | |
BB | 20 | |
CC | 30 | |
DD | 40 |
TABLE B: EXPECTED OUTCOME | ||
Category | Value | Output |
AA | 10 | 30 |
BB | 20 | 30 |
CC | 30 | 70 |
DD | 40 | 70 |
@AKHIL_RB_123 , First Create a new column
Cat =
Switch(True() ,
[Category] in {"AA", "BB"} , "Cat1" ,
"Cat2")
Now a new measure
sumx(filter(Table, [Cat]=earlier([Cat]), Table[Value])
or
sumx(allselected(Table), [Cat] = Max([Cat]) ), [Value])