Forum Discussion

Rosario's avatar
Rosario
Icon for Helper I rankHelper I
6 years ago

Create quick measure for row total

Hi All, I'm trying to get a difference percentage between rows creating a quick measure but it doesn't work. Below is an example to get the difference of Term 3 from Term 1.

 

 Achieved %
Term 12.08%
Term 313.71%
Diff %11.63%

In format field the Subtotal only add but doens't rest.

Thank U very Much. Rosario
Need Help

3 Replies

    • Rosario's avatar
      Rosario
      Icon for Helper I rankHelper I
      6 years ago

      Hi Xiaoxin thanks for your response. Would you mind to give a solution into Power BI following this link? I need and extra row below Term 3 to show the % difference from Term 3 out of term 1.

       

      Many thanks again for sharing your knowledge and time.

       

      Kind regards.

      Rosario Pineda.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        HI Rosario ,

        I can't access that link(it require to sign in and send request).
        Can you please share some fake data with the same data structure? (you can build it in excel sheet and paste correspond workbook cells area as table format)
        Regards,

        Xiaoxin Sheng