Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
  • Greg_Deckler's avatar
    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.