Average of count

[Anonymous]

Hello All, 

Another problem for me. Can you please help me calculate the average of a count?

I have a really simple measure, which counts all the rows of a table and after that i put it in the filter context of region as you can see below:

Can you help me put average number of processed transactions next to the total?

The expected result for 2019-01 is 9,944

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Create measures

Measure = COUNT('Table 2'[name])

Measure 2 = IF(ISINSCOPE('Table 2'[server name]),[Measure],AVERAGEX(ALL('Table 2'[server name]),[Measure]))

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[az38]

Hi @Anonymous 

it's pretty difficult to answer you correct without original data sample, but have a look at averagex() function.

like

CALCULATE(AVERAGEX(Table, 'Table'[Number of Invoices]))

[Anonymous]

@az38 

Thank you, but it didn't worked. Would you please let me know how can i provide you with some sample?

Atanas

[az38]

@Anonymous 

sorry, didn't mention your right pane on the screenshot

built-in matrix visual won't allow you to create a new column next to Total

If you don't need any drill-down option - use a Table. but you will need to create separate measure or column for each region, then total measure, then average.