Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

percentage not adding up when selected multiple dates

Hello everyone, i have a measure:     Percentage = VAR value1 = Sum(Value1[total]) VAR value2 = Sum(Value2[total]) Return value2/value1     say for date1 on date slicer value1 = 200,0...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    Please add [Percentage] measure into SUMX() expression instead of the measure code.

    You new measure should calculate based on [Percentage] measure.

    New Percentage =
SUMX ( VALUES ( Date[date] ), [Percentage] )

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , Create a measure like , Assuming we have common date table in this case

 

Sumx(Values(Date[date]), calculate(divide(Sum(Value1[total]), Sum(Value2[total]) )))

Anonymous's avatar
Anonymous
Not applicable
3 years ago

hello i do have a relationship with the table and date table,
but it still didnt work for some reason

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

     

    Please add [Percentage] measure into SUMX() expression instead of the measure code.

    You new measure should calculate based on [Percentage] measure.

    New Percentage =
SUMX ( VALUES ( Date[date] ), [Percentage] )

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.