Forum Discussion

ksimpkinson's avatar
ksimpkinson
Regular Visitor
5 years ago
Solved

Exclude specified filter

I have a dataset that is a combination of headcount and transactions (i.e. terminations, promotions, etc). One of the ways the terminations are categorized is by a detailed action reason. I want to ...
  • amitchandak's avatar
    5 years ago

    ksimpkinson , As per what I got it

     


    Turnover Rate =
    DIVIDE( [Total Terminations],
    CALCULATE( [Average Employee Headcount], ALL(Table[Detailed Action reason]) )

    or
    Turnover Rate =
    DIVIDE( [Total Terminations],
    CALCULATE( [Average Employee Headcount], removefilters(Table[Detailed Action reason]) )

     

    Sometimes this does not work out at that time you need to a separate table for Detailed Action reason and you use all on that

     

    Turnover Rate =
    DIVIDE( [Total Terminations],
    CALCULATE( [Average Employee Headcount], removefilters('Detailed Action reason') )

  • Greg_Deckler's avatar
    5 years ago

    ksimpkinson - You can use ALLEXCEPT or REMOVEFILTERS or KEEPFILTERS to edit context of the calculation.