Forum Discussion

spuri_78's avatar
spuri_78
Regular Visitor
1 year ago
Solved

Stuck on Divide Measure total

Hi guys,   I'm stuck at calculating Divide function. I know it should be simple. Below is the output table   Generation Headcount Turnover Turnover rate of Generation % of Total Workforce ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi spuri_78 ,

     

    I reviewed this post and it seems the problem has not been solved yet.

    I reproduced it based on your description.

    T Emp table:

    Emp TypeGeneration

    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Gen X
    Perm Gen X
    Perm Gen X
    Perm Gen X
    Perm Gen X
    Perm Gen X
    Perm Gen X
    Perm Gen X
    Perm Gen X
    Perm Gen X
    Perm Gen X
    Perm Gen X
    ABC Generation Z
    ABC Generation Z
    ABC Gen X
    ABC Gen X
    ABC Gen X

     

    Turnover table:

    Emp TypeGeneration

    Perm Generation Z
    Perm Generation Z
    Perm Generation Z
    Perm Gen X
    ABC Generation Z
    ABC Generation Z
    ABC Gen X
    ABC Gen X

     

    For the table visual you want, it is suggested to create a dim table below.

    Generation table:

    Generation

    Generation Z
    Gen X

    Relationships:

    Here's what you're getting so far.

    Tips: You can click "%" button to display the values in percentages.

    % of Total Workforce = DIVIDE([Perm Headcount],SUMX(ALLSELECTED('Generation'),[Perm Headcount]))

    % of Total Turnover = DIVIDE([Turnover Perm Headcount],SUMX(ALLSELECTED(Generation),[Turnover Perm Headcount]))

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

AllisonKennedy's avatar
AllisonKennedy
Community Champion
1 year ago

spuri_78 

 

to get the Total you just need to clear ALL filters, you may prefer to use ALLSELECTED instead of ALL: 

 

GT Perm Headcount = CALCULATE ( [Perm Headcount], ALLSELECTED() )

 

% GT Per Headcount = DIVIDE( [Perm Headcount], [GT Perm Headcount] )

 

You can of course combine these two measures into one if you prefer, or keep them separate.