Forum Discussion

Tiger2514555's avatar
Tiger2514555
Helper III
2 years ago
Solved

Get max multiple selected value from slice

I chose weeks 44 and 42, which would be 2 if it was the highest week. Less than 3 I don't understand why my data where weeks are less than weeks maximum doesn't meet the 3 criteria if weeks are...
Need Help
  • Tiger2514555's avatar
    Tiger2514555
    2 years ago

    Now I can do this, I created a new Week Create table but didn't relationship it because if I concatenate the result would be the same.
    There is a problem with LasetWeek which tells which week is the highest week.
    LasetWeek =
    VAR SelectedWeek = ALLSELECTED(WeekSlicer[Week Create])
    VAR Max_Month =
    CALCULATE(
    MAXX(
    FILTER(
    ALLNOBLANKROW(DemandSummaryAPS),
    'DemandSummaryAPS'[Week Create] IN SelectedWeek
    ),
    DemandSummaryAPS[Week Create]
    )
    )
    RETURN
    Max_Month

Tiger2514555's avatar
Tiger2514555
Helper III
2 years ago

Now I can do this, I created a new Week Create table but didn't relationship it because if I concatenate the result would be the same.
There is a problem with LasetWeek which tells which week is the highest week.
LasetWeek =
VAR SelectedWeek = ALLSELECTED(WeekSlicer[Week Create])
VAR Max_Month =
CALCULATE(
MAXX(
FILTER(
ALLNOBLANKROW(DemandSummaryAPS),
'DemandSummaryAPS'[Week Create] IN SelectedWeek
),
DemandSummaryAPS[Week Create]
)
)
RETURN
Max_Month