Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Update summarize table with a dimdate

Hi.

 

I created a virtual table using the summarize and then using conditionals i set a kpi value for each item. The last column count is a cumulative sum (from january to august) by management of the expenses incurred by the accumulated sum (from january to august) by management of the planned expenses. Photo below. 

 

 

 This table is related to another in a ratio of many to one.

 

 

Is it possible update this virtual table using the the data filters from the dimdate table?

 

 

 

 

 

  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi.

     

    I got to find a solution to dynamically update the kpis. I gave up creating a virtual table, and created a measure using the Switch function.

     

     

    I insert the hiperlinks inside the switch function, and as the calculations are updated, the kpi are also respecting the established parameters.

     

    Is was not the wat i wanted to do it, but it worked. 

     

    Thanks all for helps.

     

     

     

    regards.

     

5 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    hi, Anonymous

         I'm afraid it couldn't achieve in Power BI for now. Claculate table can't be affected by any slicer.

    It is dynamic only if when tables that creating calculate table based on changed, it will change too.

     

    Best Regards,

    Lin