Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have two tables that have visual-level filters on the same field (candidate stage/application status).
Because they both rely on Candidate Stage ("Application status"), when I click on one table, it incorrectly calculates.
The intended effect should be 0's across the board for Total Hired and & % Hired because the table being triggered is a collection of Applications still Under Review/Open.
Thoughts?
Solved! Go to Solution.
Hi @Anonymous ,
Please use the following measure for %hired:
% Hired =
CALCULATE ( COUNTROWS ( Sheet1 ), Sheet1[Candidate Stage] = "Hired" )
/ CALCULATE (
COUNTROWS ( Sheet1 ),
FILTER (
ALLSELECTED ( Sheet1 ),
Sheet1[Source of Hire] = MAX ( Sheet1[Source of Hire] )
)
)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @Anonymous ,
Please use the following measure for %hired:
% Hired =
CALCULATE ( COUNTROWS ( Sheet1 ), Sheet1[Candidate Stage] = "Hired" )
/ CALCULATE (
COUNTROWS ( Sheet1 ),
FILTER (
ALLSELECTED ( Sheet1 ),
Sheet1[Source of Hire] = MAX ( Sheet1[Source of Hire] )
)
)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @Anonymous,
but the visual filter only filters the selected country.