Forum Discussion

Standef's avatar
Standef
Helper I
2 years ago

DAX table with dynamic values based on measures

Hello everyone,   I am trying to have a table written in dax, with MIN and MAX values of a measure. I have a measure that varies based on several slicers; I woul dlike to have a table that automat...
lbendlin's avatar
lbendlin
Super User
2 years ago

You should not create calculated columns from measures. You cannot create calculated tables from measures (unless it is a single row single column table).  In both cases your measure will use a non-existent filter context.

 

The maximum you can do is create a table variable as an intermediate step in a measure definition.

Standef's avatar
Standef
Helper I
2 years ago

Thanks lbendlin ! How would I create such table variable ? 

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago
    Measure a =
Var b= summarize (c,[d])
Return countrows(b)
    • Standef's avatar
      Standef
      Helper I
      2 years ago

      Summarize is not able to be dynamic, even built with a measure unfortunately. 
      Thanks anyway!

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        That's news to me. Please try it out.