Forum Discussion

Surya1's avatar
Surya1
Icon for Helper I rankHelper I
8 years ago
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(...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-xjiin-msft's avatar
    v-xjiin-msft
    8 years ago

    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.

Surya1's avatar
Surya1
Icon for Helper I rankHelper I
8 years ago
This dax gives the sum of colb.I want the sum of col b tat comes under each cola.
vega's avatar
vega
Icon for Resolver III rankResolver III
8 years ago

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.