Forum Discussion

tebtim19's avatar
tebtim19
Icon for Helper IV rankHelper IV
6 years ago
Solved

Percent total by gender

I have data of all Linemanagers, And I made count measure per gender (Female and Male). Now I want to see in my card the percent total of each gender of the line manager.

Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    tebtim19 you can calculate the % by following measure

     

    % by Gender = 
DIVIDE ( [Count Measure], CALCULATE ( [Count Measure], ALL ( Table[Gender] ) ) )

     

    change the measure format to % and display it in any visual, if you visual it in a KPI card, make sure to filter the KPI card for each gender.

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

     

  • Anonymous's avatar
    Anonymous
    6 years ago

    To get the total you want to remove the filter.  

     

    So for example, if my report is filtered on item, I could remove the filter with the all function like so

     

    Percent of Sales = DIVIDE([Total Sales Quantity], CALCULATE([Total Sales Quantity], ALL(Items)),0)

     

     

     

     

3 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    tebtim19 you can calculate the % by following measure

     

    % by Gender = 
DIVIDE ( [Count Measure], CALCULATE ( [Count Measure], ALL ( Table[Gender] ) ) )

     

    change the measure format to % and display it in any visual, if you visual it in a KPI card, make sure to filter the KPI card for each gender.

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    To get the total you want to remove the filter.  

     

    So for example, if my report is filtered on item, I could remove the filter with the all function like so

     

    Percent of Sales = DIVIDE([Total Sales Quantity], CALCULATE([Total Sales Quantity], ALL(Items)),0)

     

     

     

     
  • v-xuding-msft's avatar
    v-xuding-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi tebtim19 ,

     

    Do the answers of Kroneborge and parry2k work for you? If yes, kindly mark the helpful answer as solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from the thread.