Filter Blank values

[Anonymous]

Hello everyone,

I have the following measures on my model:

QA Score :=
VAR QA_ActualScore =
    SUM ( [Actual Score] )
VAR QA_TotalAudits =
    DISTINCTCOUNT ( Behaviors_Details[ID1] )
RETURN
    DIVIDE ( QA_ActualScore, QA_TotalAudits )

Goal:=SWITCH(
 	TRUE(), 
	[QA Score]<0.9, "Not on Goal", "On Goal")

I have the following example:

Chris has 4 audits with their own scores,

What i need to know is if the score matches the requirements of completion, in this case if its less than 90% is not on goal, i need a measure that shows something like this

Using my measures  shows me all the audits even though they are not related with Chris

The thing is i dont know why is taking into consideration for the visual the audits that are not related with the person in this case, so I need to know how I could filter those to optimize the report.

I'm sharing the data model.

https://1drv.ms/x/s!Ag7DnkvMsR95rDDNd496pLEZU8PL?e=CQrHcu

Thanks for the help!

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

Here’s my data model:

First, I created a column in “Behaviors_details” table: 

Agent = 
LOOKUPVALUE(
    Summary[Agent],
    Summary[ID], RELATED(QA_Audits[ID])
)

Second, I created two measures which are like you created: QA Score & Goal

At last, I got the result:

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.