Create quick measure for row total

[Rosario]

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 1	2.08%
Term 3	13.71%
Diff %	11.63%

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

Thank U very Much. Rosario

[Anonymous]

HI @Rosario ,

You can add if statement to measure to check current row contents level and write correspond calculate formula for total level calculation.

Clever Hierarchy Handling in DAX

In addition, you can also take a look at following blog to know more about measure total calculate:

Measure Totals, The Final Word

Regards,
Xiaoxin Sheng

[Rosario]

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]

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