Divide function with rows and filter total value

[Anonymous]

Hi,

Kindly help me Here! I want below condition to enable in DAX

I want Divide function where Numerator needs to be a visible value of each Rows and Denominator needs to be sum  of all Rows with aplly of any filter

Example - I have Data like below, and % field need to be below cell Value (D2/D9) - i.e., Row level value divided by Total Value.

Answer will be 21% for E2 

But, the problem is, if i apply filter it will not take filtered Total Value for Denominator, Denominator Total Value will be Dynamic (it will change if apply filter ) 

Example:

Ill filter the above Table to Year 2021 only,

Result needed is like below,

Answer will be 35% for the same E2

Denominator - (Total Value) will change dynamically with respect to filter apply and we need to consider the filter context Total value as a Denominator) 

Please help here.

Thanks,

Mohanraj

@amitchandak @Fowmy @Jihwan_Kim @Greg_Deckler 

[Mohammad_Refaei]

Create a measure like this:

MyMeasure =
DIVIDE (
    SUM ( Table[Value] ),
    CALCULATE (
        SUM ( Table[Value] ),
        ALLEXCEPT ( Table, Table[Year], Table[Month] )
    )
)

Replace Table with your table name.

[amitchandak · Accepted solution]

@Anonymous , Try if, a measure like this can help 

divide(sum(Table[Value]), calculate(sum(Table[Value]), allselected(Table)))

[Anonymous]

Thanks a lot, This works