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,000
value2 =50,000
so percentage = 50000/200000 = 0.25
say for date2 on date slicer
value1 = 300,000
value2 =100000
so percentage = 100000/300000 = 0.33
when i select date1 and date2 together,
the result is 0.375 because it sums up value1 to 150,000 and value2 to 400,000 so 150000/400000 = 0.375
my desired result is to sum up the 2 percentage from date1 and date 2
so 0.25 + 0.33 = 0.58
how can i acheive that?
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.
4 Replies
- amitchandak
Super User
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]) )))
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.
it did ot work please check the other one https://community.powerbi.com/t5/DAX-Commands-and-Tips/Percentage-not-adding-up-when-selecting-mutliple-dates-on-slicer/td-p/2842283
this is my exact measure and calculation i want to use
