Update summarize table with a dimdate

[Anonymous]

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?

[v-lili6-msft]

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

[Anonymous]

Hi. How could I do this tablet based on change? Trought dax?

Thanks for the answer.

[v-lili6-msft]

hi, @Anonymous

     Table couldn't be changed by any slicer, you may try to do a measure instead of calculate table.

here is a case you can refer to:https://community.powerbi.com/t5/Desktop/Group-Measure-values-on-rows/m-p/514475#M240454

Best Regards,

Lin

[Anonymous]

Hi @v-lili6-msft thanks for the answer.

I tried to use the link tips that you recommended, but I could not make it work.

I put a simplified model of powerbi in the link below. Could you try to steer me from the real data?

https://drive.google.com/file/d/1rdPgomBzXXQ_htSRrEgCfqEW07_D3MtO/view?usp=sharing

My doubts:

When I change the date (from the d_Date  table), I can change the measures 2 and 3. However I can not change the KPIs 3 and 4 (from the virtual tables created with the summarize).

regards.

[Anonymous · Accepted solution]

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.