Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Union data - Create new table / common table for different data set output

Hi all,   I am stuck with a report , where I have below representation of data .   Above 4 Table comes from different dataset , Customer wants to see as combined value whereas there is no c...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

     

    A similar effect can be achieved by creating a calculated table and adding a calculate filter through the dax function. Refer to below formula:

    Table =
SUMMARIZECOLUMNS (
    FactTable[Position],
    "result1", CALCULATE ( SUM ( FactTable[Value] ), FactTable[Category] = "a" ),
    "result2", CALCULATE ( SUM ( FactTable[Value] ), FactTable[Category] = "b" ),
    "result3", CALCULATE ( SUM ( FactTable[Value] ), FactTable[Category] = "c" ),
    "result4", CALCULATE ( SUM ( FactTable[Value] ), FactTable[Category] = "d" )
)

     

    Best Regards,
    Adamk Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

 

A similar effect can be achieved by creating a calculated table and adding a calculate filter through the dax function. Refer to below formula:

Table =
SUMMARIZECOLUMNS (
    FactTable[Position],
    "result1", CALCULATE ( SUM ( FactTable[Value] ), FactTable[Category] = "a" ),
    "result2", CALCULATE ( SUM ( FactTable[Value] ), FactTable[Category] = "b" ),
    "result3", CALCULATE ( SUM ( FactTable[Value] ), FactTable[Category] = "c" ),
    "result4", CALCULATE ( SUM ( FactTable[Value] ), FactTable[Category] = "d" )
)

 

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.