Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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. RosarioHI @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
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |