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
Thank you for your time.Can you please help me with the dax solution
vega's avatar
vega
Icon for Resolver III rankResolver III
8 years ago

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.

 

  • 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.