Percentage of total - string

[samc_26]

Hi, I have a table with multiple rows showing Qualifications which have been either 'completed', 'expired' or 'not qualified' and need to show only 'completed' as a percentage of all rows (including completed). I have been trying to find a measure guide online but am struggling and am still learning the basics of dax. Can anyone tell me how to write this measure please? The columns are as below and the table holding all the data is called 'Quals'. The values are 'count of Employee Name' and th column with the data is 'qualification status'. Thank you!

[samc_26]

Thank you!!! 😁 You have saved me so much time and hopefully I can use these formulas to understand dax better now! 🌟

[rsbin · Accepted solution]

@samc_26 ,

First, create a measure that calculates the number of completed records:

Complete_Count = CALCULATE( COUNTA( Quals[Qualification Status] ),
                      FILTER(Quals, Quals[Qualification Status] = "Complete" ))  

Then to calculate percentage, use the DIVIDE function:

Compete_Percent = DIVIDE( [Complete_Count], COUNTA(Quals[Qualification Status]), 0)
                  //You can replace the second argument with another Count Measure if preferred

Then just use the Column Tools to change the format from a decimal to percent.

Hope this gets you where you need to go.

Regards,

[danniohere46_1]

Can this be done with multiple columns?

[rsbin]

@danniohere46_1 ,

Yes, this can be done with multiple columns.

Please provide details in a new thread and either I or someone else will be able to assist.

Preferably, please include small set of sample data as text, not as a picture.
Regards,