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.
Thank you for your time.Can you please help me with the dax solution
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.
Did you form a relationship between the two tables? If you did not then you are going to get the sum total for all value in col a. After forming the relationship, you get the following:
The solution that v-xjiin-msft posted should also work as well.