Forum Discussion
Anonymous
6 years agoNot applicable
display a DAX table through a measure
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 Phase...
- 6 years ago
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.
amitchandak
Super User
6 years agoTry Unpivot and then you should be able, to sum up