Visual filters messing up Calculations

[Anonymous]

I have two tables that have visual-level filters on the same field (candidate stage/application status).

1. One table summarizes open applications by filtering on any application that is "Under Review".
   
   
2. The other table is a collection of Total Applications submitted and contains a measure that calculates what percentage of those applications were hired.
   
   

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?

[v-deddai1-msft · Accepted 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

[mwegener]

Hi @Anonymous,

but the visual filter only filters the selected country.