I have a measure to find the missing lectures by a student in Card Visual. I want to Lookup the value from measure output and search the related content in other dimension tables and display it via other measure.
Missing Lectures = VAR classlectures = FILTER ( ALL ( Course[Lecture Index] ), NOT Course[Lecture Index] IN VALUES ( Attendance[Lecture Index] ) ) RETURN CONCATENATEX ( classlectures, [Lecture Index], "-")
The output visual is
Requirement: I have related lecture contents in lookup table. I want to show the related course contents for these missing lectures seamlessly, preferably, by a measure.
After, it might be possible to find the judgment that why student got less marks due to missing concepts (absence in class lectures).