Forum Discussion

Suhel_Ansari's avatar
Suhel_Ansari
Icon for Helper V rankHelper V
8 months ago
Solved

Wrong Total in Table

Hi all, I am getting worng total, I am tryint to calcualte the price of Power BI Licsenes cost for PPU, PRO and Free users using the following table and dynamically calculate the total which I am get...
Need Help
  • Suhel_Ansari's avatar
    Suhel_Ansari
    8 months ago

    Hi GeraldGEmerick  - I got the answer using the ADDCOLUMNS  however I have to use the multiple ADDCOLUMNS can you please help me to optimze this measure. Thanks 

     

Suhel_Ansari's avatar
Suhel_Ansari
Icon for Helper V rankHelper V
8 months ago

Hi GeraldGEmerick  - I got the answer using the ADDCOLUMNS  however I have to use the multiple ADDCOLUMNS can you please help me to optimze this measure. Thanks 

 

GeraldGEmerick's avatar
GeraldGEmerick
Icon for Memorable Member rankMemorable Member
8 months ago

Suhel_Ansari From what I can see, you can move the formulat for TOTAL into your Result variable. That way it isn't calculated unless it is necessary.