Forum Discussion

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
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.
W35_Add calculated Row in table.pbix26 KB

v-angzheng-msft

Community Support

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.

W35_Add calculated Row in table.pbix26 KB