Forum Discussion

duybachhpvn's avatar
duybachhpvn
Frequent Visitor
4 years ago
Solved

Dynamic virtual summarized table

Hi, is there a way to write a DAX measure to obtain a dynamic virtual table that will give me the desire result as in below scenario?   Basically the result I would want is the final Dynamic virtua...
DAX
dynamic table
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi duybachhpvn ,

     

    The tables we create (new tables) are static and cannot be created dynamically.

    But SUMMARIZE can create a dynamic virtual table from two table, but the table can not be return. Let me prove it to you.
    Before doing so, create a relationship between these tables.

    I create a measure to return which is the result of summarize.

    SUMMARIZE TABLE = 
var _1 = SUMMARIZE('Cost',[PeriodName],[ScenarloName],[Cost])
return
CONCATENATEX(_1,[PeriodName] &" "&[ScenarloName]&" "&[Cost],"
")

    result:

     

     

    Pbix in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

amitchandak's avatar
amitchandak
Super User
4 years ago

duybachhpvn , You can not create a dynamic calculated table. Tables once created will be static. So your measures will not change based on slicer values

 

If you want add measures of another tables try like, in var of measures  (that will be dynamic

 

measure ,

var _tab = addcolumns(summarize(Table, 'Common Dim1'[Column], , 'Common Dim2'[Column] ), "_1", [Measure1]

,"_2", [Meausre 2] )

 

You can add columns in summarize or addcolumns as per need