Average of % Win Rate Measure

[Jitmondo]

Hi All,

I have a measure that calculates Win Rate % - I want to work out the average win rate percentage accross a set of criteria example below. The win rate is a measure so is not easily averaged in a dax formula I know of .... I should be receiving the average win rate across all as 17.75 but I cant get it to work.

Item     Win Rate

Cars     10%

Bikes     20%

Trucks   33%

Boats     8%

I also tried this measure 

Average % of Closed Won = CALCULATE(AVERAGEX('Account Performance Reference Table','Account Performance Reference Table'[Closed Won Win Rate]))

However this gives me a number which matches the total win rate percentage instead of the average 😞

Any ideas on what I could do here?

Thanks

[Jitmondo]

Thanks @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]

@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 🙂

[SpartaBI · Accepted solution]

@Jitmondo 
Measure = AVERAGEX(VALUES('TableName'[Item]), [Win Rate])

Showcase Report – Contoso By SpartaBI