display a DAX table through a measure

[CR]

Hi all,

I've a table1:

Type	Phase1	Phase2	Phase3
Type1	12
Type2		10
Type3		8	14

and I would like to get the following table in a visual:

Phase	Data
Phase1	12
Phase2	18
Phase3	14

To get this result, I get the following code:

Table2 = 
UNION(
    SUMMARIZE(Table1;"Phase";"Phase1";"Data";SUM(Table1[Phase1]));
    SUMMARIZE(Table1;"Phase";"Phase2";"Data";SUM(Table1[Phase2]));
    SUMMARIZE(Table1;"Phase";"Phase3";"Data";SUM(Table1[Phase3]))
)

 But I cannot create a new table in live connection so I assume it has to be stored in a measure.

Measure = 
var tableTemp = 
                UNION(
                    SUMMARIZE(Table1;"Phase";"Phase1";"Data";SUM(Table1[Phase1]));
                    SUMMARIZE(Table1;"Phase";"Phase2";"Data";SUM(Table1[Phase2]));
                    SUMMARIZE(Table1;"Phase";"Phase3";"Data";SUM(Table1[Phase3]))
                )
RETURN
...

The issue is I don't see how to proceed now with the RETURN...

Any idea ?

Regards,

CR

[Greg_Deckler · Accepted solution]

Well, that's a pickle because normally you would do something like:

Measure = 
var tableTemp = 
                UNION(
                    SUMMARIZE(Table1;"Phase";"Phase1";"Data";SUM(Table1[Phase1]));
                    SUMMARIZE(Table1;"Phase";"Phase2";"Data";SUM(Table1[Phase2]));
                    SUMMARIZE(Table1;"Phase";"Phase3";"Data";SUM(Table1[Phase3]))
                )
RETURN
  SUMX(FILTER(tableTemp,[Phase] = MAX('Table'[Phase])),[Data])

But, this would require that you have those Phase1, Phase2, Phase3 for your visual.

I cannot think of a way around this. With a Live connection, you will have to adjust the model by either unpivoting those columns in the model (on the live data source you are connecting to) or create a disconnected table in the live data source you are connecting to.

[CR]

hum hum... indeed, to be discussed with the guy in charge of the cube !

Thanks @Greg_Deckler 

[amitchandak]

Try Unpivot and then you should be able, to sum up

https://radacad.com/pivot-and-unpivot-with-power-bi