Forum Discussion
Get max multiple selected value from slice
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
It doesn't work. lbendlin
My data like this:
| Week Create | ID | item | quantity | Week Due | Check Measure | Week By Week |
| 42 | F01 | A2 | 30 | 40 | 3 | -30 |
| 44 | F01 | A2 | 20 | 40 | 2 | 20 |
| 42 | F02 | A3 | 10 | 41 | 3 | -10 |
| 44 | F02 | A3 | 10 | 41 | 2 | 10 |
| 42 | F05 | A5 | 60 | 42 | 3 | -60 |
| 44 | F06 | A6 | 50 | 42 | 2 | 50 |
My Week By Week value comes from quantity, which is viewed from Check Measure. If it is 1, show the quantity value of the highest week minus the value of the lowest week. If it is 2, show the quantity value of the highest week. If it is 3, show the quantity value of minimal week and is a negative value Which is my Check Measure to find which data is 1,2,3 which is compared to Measure Laset Week which I use to find the highest Week Create selected from the Slicer.
If you need the file to review, I can send it to you in a private message.
My Check Measure :
Your sample data is inconsistent with the code. [Laset Week] and [demandID] are missing.
