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.

     

amitchandak's avatar
amitchandak
Super User
4 years ago

marial16 , if you want to add in visual table I doubt you can do that

 

The workaround is to create data tables and append them. But they will not take slicer values

marial16's avatar
marial16
Helper II
4 years ago

I have no idea how to do that,

 

any links or documentation that you could suggest?