Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |