Forum Discussion
Measure notactioned
bzeeblitz Make sure that list1 and list2 are related by the item number field. You can create a relationship in the "Model" view in Power BI.
DAX
ItemNumberMeasure =
VAR SelectedDate = SELECTEDVALUE(list1[Date])
RETURN
CALCULATE(
FIRSTNONBLANK(list2[Item number], 1),
list2[Date] = SelectedDate
)bzeeblitz Check data type in both of them Table
ItemNumberMeasure =
VAR SelectedDate = SELECTEDVALUE(list1[Date])
RETURN
CALCULATE(
FIRSTNONBLANK(list2[Item number], 1),
list2[Date] = VALUE(SelectedDate)
)Additionally, to get the item numbers from list1 where the status in list2 is not "actioned", you can create a measure like this:
NotActionedItemNumbers =
CALCULATE(
CONCATENATEX(
FILTER(
list1,
RELATED(list2[Status]) <> "actioned"
),
list1[Item number],
", "
)
)
I'm getting error fetching Data for the visual calculation error in measure.dax comparison operations do not support comparing values of type Date with values of type text.consider using the value or format function to convert one of the values
bzeeblitz Check data type in both of them Table
ItemNumberMeasure =
VAR SelectedDate = SELECTEDVALUE(list1[Date])
RETURN
CALCULATE(
FIRSTNONBLANK(list2[Item number], 1),
list2[Date] = VALUE(SelectedDate)
)
Additionally, to get the item numbers from list1 where the status in list2 is not "actioned", you can create a measure like this:
NotActionedItemNumbers =
CALCULATE(
CONCATENATEX(
FILTER(
list1,
RELATED(list2[Status]) <> "actioned"
),
list1[Item number],
", "
)
)