Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## 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..

 Name Score Anna 1 Alan 2 Tobi 3 Sam 2 Tonny 2 Toffon 4 Bram 5
1 ACCEPTED SOLUTION
Super User

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 7
Super User

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

Helper I

I got syntax error

Super User

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

Helper I

hi collin, my bad the syntax is correct, i didn't change the column name, however how can I change that to percentage?

Super User

Good day kangkopi15,

If you are working in Power BI Desktop there are several ways of presenting a measure as a percentage. The most straightfoward is to use the format drop-down on the modelling ribbon. For example, I created a simple measure for demonstration purposes, Percent = 1/3, then formatted it as "Percentage" with 2 decimal places.

the procedure is similar if working in Excel,

Hope this helps

Super User

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?

Helper I

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%

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Join our Community Sticker Challenge

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors