Forum Discussion
Divide function with rows and filter total value
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
Anonymous , Try if, a measure like this can help
divide(sum(Table[Value]), calculate(sum(Table[Value]), allselected(Table)))
3 Replies
Anonymous , Try if, a measure like this can help
divide(sum(Table[Value]), calculate(sum(Table[Value]), allselected(Table)))
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.
