Not getting total for Switch function

[Nagesh20]

Hi All,

Please someone advice how to get the total for Max column (using with Switch function)

Backup calculation is given below

Cumulative =

IF([TotalValue]<>BLANK(),

CALCULATE([TotalValue],

FILTER(ALL(Calender[Date]),Calender[Date]<=MAX(Calender[Date]))))

Max =

Var _max=maxx(filter(allselected(Table1), Table1[Product] = max(Table1[Product]) ), Table1[Date])

return

Switch ( true(),

Max(Calender[Date]) = _max ,[Cumulative],

Max(Calender[Date]) < _max , 0 ,

blank())

[v-jialongy-msft]

Hi @Nagesh20 

Here are some aspects that I suggest can be considered.

1. Ensure Relationships: Make sure that there is a relationship between 'Table1[Date]'and 'Calender[Date]' if they are meant to interact. Without a proper relationship, date comparisons and aggregations might not behave as expected.

2. Refined Max Calculation: 

Max =
VAR _maxDateForProduct = CALCULATE(
MAX(Table1[Date]),
ALLSELECTED(Table1)
)
RETURN
SWITCH(
TRUE(),
MAX(Calender[Date]) = _maxDateForProduct, [Cumulative],
MAX(Calender[Date]) < _maxDateForProduct, 0,
BLANK()
)

Best Regards,

Jayleny

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