how to calculate parent row total with BI

[dombarg]

hello my freinds.

i got a problem.i had built following table and calculation in excel (in order to summarze,i made them collapsed).but i can't do same in BI.I am not very familar with DAX.I've searched in web for solution but I'm not able to customize them for my prblem.would you please advice me?

each column in the picture reffers to a field in Database.I need to design a measure in BI so that i can use it for diffrents years.

[v-shex-msft · Accepted solution]

Hi @dombarg,

AFAK, current dax measure formula not works properly on total level.

In my opinion, you need to add some conditions to check current row content if it is total level and write specific formula who works on that level.

Reference link:

Detecting Total, Subtotal and Hierarchy Levels in PowerPivot

Understanding ALLSELECTED

Regards,

Xiaoxin Sheng