Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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)...
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.