Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try if, a measure like this can help 

     

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

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Try if, a measure like this can help 

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks a lot, This works