Handle Blank Results

[Atf23]

Hi there,

I have the following typical model

and the content of the tables is as follows

I need to display results of some selected user so that if there is no equivalent row in the data I return "to do"
using the native column "status" gave Table 1
using a calculated measure gave the Table 2 such that:
status_m = 

VAR s =  CALCULATE ( MIN (results[status] ) )

RETURN IF( ISBLANK(s), "to do", s )

what I want to get (giving the selected course and user) is as follows:

I appreciate any idea 🙂 Thank you

[Jihwan_Kim]

Hi,

I am not sure if I understood your datamodel correctly, but please check the below picture and the attached pbix file.

Status measure: = 
VAR _course =
    MAX ( Courses[Course] )
VAR _name =
    MAX ( Users[Name] )
VAR _evaluation =
    MAX ( Evaluations[Evaluation] )
RETURN
    COALESCE (
        MAXX ( FILTER ( Result, Result[Course] = _course ), Result[Status] ),
        "to do"
    )

[Atf23]

Thank you for your prompt response but what I already git this output using the measure "status_m". In fact, what I want to get :
If "course 2" is selected and user "A" is selected, the table must only show results of the user "A" for all of the 3 evalauations of "course 2".

I don't want to results of the user "A" for other courses to be displayed.