Georgia has attended:
Power BI Modelling, Visualisation and Publishing course
Percentage of total for string column
Hi,
I have a data set where I need to calculate the inspection rate of "No" (the other option being "yes") by the total number of inspections each year. I know the quick excel calulation would be:
count of "No"/Total inspections*100 but I don't know how to do this in power BI, please help!
Best
RE: Percentage of total for string column
Hi Georgia,
Thank you for the forum question.
If you want to display the percentage of NO out of all
Count no = DIVIDE(COUNTAX(filter(the name of your table,[inspection]="No"),counta(the name of your table[inspection])),counta(the name of your table[inspection]),0)
You will need to change the DAX to your table and column names.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
