Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Visual filters messing up Calculations

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?

Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    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

2 Replies

  • mwegener's avatar
    mwegener
    Icon for Most Valuable Professional rankMost Valuable Professional
    5 years ago

    Hi Anonymous,

     

    but the visual filter only filters the selected country.

     

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    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