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.

     

     

spuri_78's avatar
spuri_78
Regular Visitor
1 year ago

AllisonKennedy 

 

Thanks for your reply. Sorry, I should have been clearer in my intial post. I already have the measure for Total Perm Headcount which is CALCULATE(COUNTROWS(FILTER('T Emp,'T Emp'[Emp Type]="Perm")) and gives the value 117. What I want is the % of 48/117.

 

The individual measure for Perm Headcount for Generation Z is CALCULATE(COUNTROWS('T Emp'),
FILTER ('T Emp','T Emp'[Generations]="Generation Z"),
FILTER('T Emp','T Emp'[Emp Type]="Perm")) which gives 48.

 

Hope this makes sense.