Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter Blank values

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!

 

Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    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.

1 Reply

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    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.