Forum Discussion
Update summarize table with a dimdate
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.
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
- Hi. How could I do this tablet based on change? Trought dax?
Thanks for the answer.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
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.