Forum Discussion
Percentage not adding up when selecting mutliple dates on slicer
Hello everyone, i have a measure: Percentage =
VAR Totalrevenue = Sum(Value1[total])
VAR oldvalue = Calculate(Sum(Value1[total]),[Column] = "A",Filter(Datetable [Date] < DATE(2022,10,1)...
Hi Anonymous ,
Please have a try.
New Percentage = SUMX ( VALUES ( Date[date] ), [Percentage] )If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output with more details.
How to Get Your Question Answered Quickly
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Please have a try.
New Percentage =
SUMX ( VALUES ( Date[date] ), [Percentage] )If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output with more details.
How to Get Your Question Answered Quickly
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.