Forum Discussion
Helper IIIAverage of % Win Rate Measure
Jitmondo
Measure = AVERAGEX(VALUES('TableName'[Item]), [Win Rate])
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.Showcase Report – Contoso By SpartaBI
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
SpartaBI Logo
Helper IIIThanks SpartaBI this worked perfectly, at first I thought there was still an issue but I was using the table measure twice instead of using your logic to say calculate by item and then measure !!!
Really appreciate the help 🙂
- SpartaBI
Community Champion
Jitmondo my pleasure 🙂
Hey, check out my showcase report - got some high level stuff there 🙂
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 🙂