Forum Discussion

alvin199's avatar
alvin199
Helper III
4 years ago
Solved

Question on Calculate Percentage

I have a sample data like this in table called Worker.   I would like to create a DAX to calculate percentage of people in each station and then plot it into a bar chart. The DAX I am using ...
Need Help
  • PijushRoy's avatar
    PijushRoy
    4 years ago

    Hi alvin199 

    Please try this

    Column = CALCULATE(
    COUNT('Table'[Station]),ALL('Table'[Station]))/COUNT('Table'[Station])
    Calculate % not greater than 100% DAX

    If you have any question, please let me know.
    If solve your requirement, please mark this answer as SOLUTION
    If this comment helps you, please LIKE this comment/Kudos
PijushRoy's avatar
PijushRoy
Community Champion
4 years ago

Hi alvin199 

Please try this

Column = CALCULATE(
COUNT('Table'[Station]),ALL('Table'[Station]))/COUNT('Table'[Station])
Calculate % not greater than 100% DAX

If you have any question, please let me know.
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos