Forum Discussion

marial16's avatar
marial16
Helper II
4 years ago
Solved

Add calculated Row in table

Hallo,  i import 3 tables from SP to help me create a KPI graph Can i add a row at the table in BI to calculate (division) of 2 rows above? (Last Row)   Example Own Staff  Contractor 157 ...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, marial16 

    You could create measures and change the Total field to the division you want.

     

    Like this:

    _Own Staff = 
    IF(
        ISINSCOPE('Table'[Index]),SUM('Table'[Own Staff ]),
        DIVIDE(
            CALCULATE(SUM('Table'[Own Staff ]),FILTER(ALL('Table'),'Table'[Index]=MAX('Table'[Index]))),
            CALCULATE(SUM('Table'[Own Staff ]),FILTER(ALL('Table'),'Table'[Index]=MAXX(FILTER(ALL('Table'),'Table'[Index]<MAX('Table'[Index])),[Index])))
        )
    )

     

    Result:

    Please refer to the attachment below for details. Hope this helps.

     

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-angzheng-msft's avatar
v-angzheng-msft
Community Support
4 years ago

Hi, marial16 

 

This does not work when there are more rows in the table, and new rows cannot be added row by row. This is not the way power bi works. You can create a measure to display it next to it. If you can accept the display by row, you can turn on show value on the row.

Yes, you can use an Excel file that already contains calculations, and you can choose to import the calculations of the model in the import feature.

 

 

Best Regards,
Community Support Team _ Zeon Zheng


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.