How to work out averages based on many categories

[lennox25]

Can someone help me? I need to create a visual that displays the average per category? How do I do this? Can it be done with one measure/column? Currently I have created a number of columns per issue and then created an average measure per issue.

There are filters on visual on store number and date.

I have uploaded a sample power bi file which will hopefully explain what Im after.

https://drive.google.com/file/d/1fFS2O-SYE1IBKjfJHlgc8CPTEHNi86-i/view?usp=sharing 

[v-jingzhang]

Hi @lennox25 

Sorry I don't 100% understand the problem. You want to calculate the average of what? Does the "category" refer to "Issue" in your data? To calculate an average, usually using a measure will be better. Can you show the expected average result based on the current sample data? We need to know what is the average and the Math logic you want to calculate it. 

Best Regards,
Community Support Team _ Jing

[lennox25]

Hi @v-jingzhang - please see sample file. What im trying to do is get away from creating a column for each issue and then a measure to work out the average of each issue.

Issue Column example -  Issue Column Blockage = If('issues'[Issue] = "Blockage", 1, 0)

Average Measure example - Average Action No Signs = SUM('issues'[Issue Column No signs])/distinctcount('issues'[Store No])

https://drive.google.com/file/d/1sDbn0La6O8CLFX7xmYCY17cUdHD2mkFm/view?usp=sharing