Forum Discussion

kangkopi15's avatar
kangkopi15
Icon for Helper I rankHelper I
2 years ago
Solved

Percentage of value

Dear experts,
I am quite new to DAX, I need a little advice. I have this table, and I need to make a percentage of the score.
The output would be
Score 1 = 14.28%
Score 2 = 42.86%

and so on..

 

NameScore
Anna1
Alan2
Tobi3
Sam2
Tonny2
Toffon4
Bram5
Need Help
  • collinsg's avatar
    collinsg
    2 years ago

    Good day kangkopi15,

    It looks like you want to find the percentage of scores which are 1, 2...5. If this is the case you can create a matrix visual, put "Score" in rows and use this measure for the values.

    Percentage frequency of score =
    VAR thisScore = SELECTEDVALUE(tbl[Score])
    VAR countOfAllScores = CALCULATE(COUNTROWS('tbl'),REMOVEFILTERS('tbl'))
    VAR countOfScore = CALCULATE(COUNTROWS('tbl'),REMOVEFILTERS('tbl'),'tbl'[Score]=thisScore)
    RETURN DIVIDE(countOfScore, countOfAllScores)

    Hope this helps

7 Replies

  • collinsg's avatar
    collinsg
    Icon for Solution Sage rankSolution Sage
    2 years ago

    Good day kangkopi15,

    It looks like you want to find the percentage of scores which are 1, 2...5. If this is the case you can create a matrix visual, put "Score" in rows and use this measure for the values.

    Percentage frequency of score =
    VAR thisScore = SELECTEDVALUE(tbl[Score])
    VAR countOfAllScores = CALCULATE(COUNTROWS('tbl'),REMOVEFILTERS('tbl'))
    VAR countOfScore = CALCULATE(COUNTROWS('tbl'),REMOVEFILTERS('tbl'),'tbl'[Score]=thisScore)
    RETURN DIVIDE(countOfScore, countOfAllScores)

    Hope this helps

      • collinsg's avatar
        collinsg
        Icon for Solution Sage rankSolution Sage
        2 years ago

        kangkopi15

        1. Did you replace "tbl" with the name of your table?
        2. Is your "Score" column a number type?

        The syntax is correct and gives the answers to the problem.

        Hope this helps

  • zenisekd's avatar
    zenisekd
    Icon for Super User rankSuper User
    2 years ago

    Could you explain better how do you want to calculate it? Your description makes very little sense. 
    is 1 = 14,28%
    so 3 = 3*14,28%?

    Or do you want to calculate a % of a grand total?

     

    • kangkopi15's avatar
      kangkopi15
      Icon for Helper I rankHelper I
      2 years ago

      I am looking for the score percentage..
      score 1, there is only one person put score 1, so from the total people who participated (7) the ratio or percentage of score 1 is 1/7 which would be around 14,28%