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

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
Anonymous
Not applicable
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.