Forum Discussion

Marcus_S's avatar
Marcus_S
Frequent Visitor
3 years ago

TotalYTD untill to today with extra Filter

Hello everyone,

 

i´ve a measure

 

capytd 1 = 
TOTALYTD (
    SUM ( 'Calendar Entry'[Capacity (Total)] ),
    'Date'[Date], 
    FILTER (ALL ( 'Date'[Date] ), 'Date'[Date] <= MAX ( 'Date'[Today] ))
)

 

Buit i need this extra filter included

 

'Calender Entry'[Work Center No_]= "APG00800"

 

I tried many ways, but nothing works 😞

 

Thanks a lot

Need Help

2 Replies

  • Kishore_KVN's avatar
    Kishore_KVN
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hello Marcus_S , tried this? If not try it once and let us know the result. 

    capytd 1 = 
TOTALYTD (
    SUM ( 'Calendar Entry'[Capacity (Total)] ),
    'Date'[Date], 
    FILTER (ALL ( 'Date'[Date] ), 
'Date'[Date] <= MAX ( 'Date'[Today] ) && 'Calender Entry'[Work Center No_]= "APG00800")
)

     

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

    • Marcus_S's avatar
      Marcus_S
      Frequent Visitor
      3 years ago

      Hello Kishore_KVN ,

       

      i treid it, but doesn´t work

      Error-Message (Translated from deepl):

      No single value can be determined for the column "Work Center No_" in the table "Calendar Entry". This can happen when a measure formula refers to a column with many values without specifying an aggregation such as MIN, MAX, COUNT or SUM to get a single result.

       

      Thanks