how to divide specific rows to sum of another specific rows

[dombarg]

hello.

I need to divide specific rows (with specfic filter) to sum of another specific rows.indeed,following picture explains my problem better than me.highlighted text in 'measure' column shoulde be divided to highlighted numbers in the balance filed.for this,i've writen measure called 'to current asset'.but it returns wrong numbers.how can i edit that?what right DAX?

thank u 

[v-huizhn-msft]

Hi @dombarg,

Please try the following formula and check if it works fine.

to current assert=
[measure]
    / CALCULATE (
        SUM ( '1396_09_21_BS'[balance] ),
        ALLEXCEPT ( '1396_09_21_BS', '1396_09_21_BS'[first column] )
    )

If there is till issue, please share your .pbix file for further analysis. It's hard to trouble shoot it without sample table.

Best Regards,
Angelia

[dombarg]

hi again.thank u.

your DAX is perfect.but there is a problem in that.

the third column ([عنوان کل] ) is filter contex of another parent(via page filter)  and when i use your DAX,it ignores those filter and calculate the ratio to all parent.how can i limit your DAX to filtered contex?thanks  

[v-huizhn-msft]

Hi @dombarg,

Please mark the right/helpful reply as answer. More people will learn new things here.  If you haven't, please feel free to ask.

Best Regards,
Angelia

[v-huizhn-msft]

Hi @dombarg,

There is no way to get the value in page filter used automatically. If you use [عنوان کل]=1 in page level, please add a filter limit in the DAX and check if works fine.

Best Regards,
Angelia