Forum Discussion
display a DAX table through a measure
- 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.
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.
- Anonymous6 years agoNot applicable