Forum Discussion
Percentage met calculation
I have the following data
I want to show in the bar chart a %met which will be the total of the met_first = True compare with the total of tickets
fr example Dec has 105 = true and 10 = false the total count 115 I want to show the 91% in the bar chart. I am new to power bi so I am not sure ow to get that calculation and if I can get tips what learnings to use to get better at DAX
liliana3186 here is a link to a sample file with a generic solution to what you need:
Percentage met calculation.pbix
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBI
4 Replies
- SpartaBI
Community Champion
liliana3186 hi will PM you
- SpartaBI
liliana3186 here is a link to a sample file with a generic solution to what you need:
Percentage met calculation.pbix
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBIThank you. any resources you can recommend for me to practice DAX and learn ?
- SpartaBI
liliana3186 that's easy 🙂
Everything you need is in one place: www.sqlbi.com
They are the best.
P.S. Will appreciate your kudos on my messages and check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas.
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up over there if you liked it 🙂
