topic Re: Handle Blank Results in DAX Commands and Tips

Handle Blank Results

Anonymous — Tue, 27 Jun 2023 15:38:02 GMT

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

Re: Handle Blank Results

Jihwan_Kim — Tue, 27 Jun 2023 17:33:45 GMT

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" )

Re: Handle Blank Results

Anonymous — Wed, 28 Jun 2023 06:57:09 GMT

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.