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 % T...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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'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