Forum Discussion
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...
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hello i do have a relationship with the table and date table,
but it still didnt work for some reason
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.