Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Create a measure that combines measures into same column

Hi everyone,   I need to create a measure that combines column values and measures into one table. I had to create custom measures to get a custom count value for INT0 from another table.    Tabl...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous ,

    Try

    Create a new Table

     

    Union(
selectcolumns(Table1, Table1[INTRANK MEASURE],"Count Measure" , sum(Table1[Count Measure])),
selectcolumns(Table2, Table2[INTRANK MEASURE], "Count Measure", sum(Table2[Count Measure]))
)
OR
Union(
selectcolumns(Table1, "INTRANK MEASURE",Table1[INTRANK MEASURE],"Count Measure" ,Table1[Count Measure]),
selectcolumns(Table2,"INTRANK MEASURE" ,Table2[INTRANK MEASURE],"Count Measure" ,Table2[Count Measure])
)

     

     

    OR a new dimension table and join with both the tables

     

    Union(
all(Table1[INTRANK MEASURE]),
all(Table2[INTRANK MEASURE])
)

     

    And create a new measure

    Count = sum(Table1[Count Measure])+ sum(Table2[Count Measure])

     

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous ,

Try

Create a new Table

 

Union(
selectcolumns(Table1, Table1[INTRANK MEASURE],"Count Measure" , sum(Table1[Count Measure])),
selectcolumns(Table2, Table2[INTRANK MEASURE], "Count Measure", sum(Table2[Count Measure]))
)
OR
Union(
selectcolumns(Table1, "INTRANK MEASURE",Table1[INTRANK MEASURE],"Count Measure" ,Table1[Count Measure]),
selectcolumns(Table2,"INTRANK MEASURE" ,Table2[INTRANK MEASURE],"Count Measure" ,Table2[Count Measure])
)

 

 

OR a new dimension table and join with both the tables

 

Union(
all(Table1[INTRANK MEASURE]),
all(Table2[INTRANK MEASURE])
)

 

And create a new measure

Count = sum(Table1[Count Measure])+ sum(Table2[Count Measure])