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 w...
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.