Forum Discussion
Solved
dax
I have a table col a colb x 0 x 1 y 2 y 0 y 1 z 0 I want to create a new table New Table col A col B(...
Hi Surya1,
In your scenario, you can use SUMMARIZE() function to create a new calculated table. Please refer to following sample:
Table-2 = SUMMARIZE ( 'Table-1', 'Table-1'[col a], "col B", SUM ( 'Table-1'[col b] ) )
Thanks,
Xi Jin.
You will select New Table -> The formula will be the following:
col a = DISTINCT(Table1[col a])
You will then go to the Relationships tab and form a relationship between the col a of both tables.
Then return to the new table and select New Column -> The formula will be:
Col b := CALCULATE(SUM(Table1[col b]))
Where Table1 is the original table name.
This dax gives the sum of colb.I want the sum of col b tat comes under each cola.