Forum Discussion

Ivan9485's avatar
Ivan9485
Frequent Visitor
4 years ago

Calculate Percentage

Im working with this table that shows a list of workers, the columns are tasks where "1" represents that the worker was able to do it while "0" means they failed. I want to calculate their score in percentage as you can see in the last column. I've seen other related posts but im having a hard time understanding DAX. Any help is appreciated.

 

Need Help

2 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    4 years ago

    Hi Ivan9485 ,

    Try this:


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel

     

     

    Score = 
var _task1 = MAX(Table(Task1)
var _task2 = MAX(Table(Task2)
var _task3 = MAX(Table(Task3)
var _task4 = MAX(Table(Task4)
var _task5 = MAX(Table(Task5)
Total = _task1 + _task2 +_task3 +_task4 +_task5
Percentage = Divide(Total,5)
return Percentage


     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Ivan9485 ,

     

    Is this the original table or a matrix visual?

    Do you want a column or a measure?

     

    Best Regards,

    Jay