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
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.
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.