Average on Direct Query

[IgorS]

Hello,

I have problem in report where I use Direct Query to import data.

When I was importing data to power BI it was easy for me to calculate number of lines in order and then make average of it on Visualization.

But now I have to use measure. ANd I have it 

Number of lines = COUNTA(PozycjaZlecenia[pz_ID])

It measure number of lines correctly but when I put it on visualization, I can't make average of it. Would You help how to 

[v-chuncz-msft · Accepted solution]

@IgorS 

You may refer to the posts below.

• https://community.powerbi.com/t5/Desktop/Average-of-a-measure-for-each-value-of-the-years/m-p/312310...
• https://community.powerbi.com/t5/Desktop/Change-table-visualization-total/m-p/323290#M144103

[IgorS]

Thanks a lot.

I don't understand this way but once I made one mesure counting lines and then another masure making average of this first one, it worked. So problem solved.

[Greg_Deckler]

Sample data would clearly help here. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

But why can't you just use AVERAGE or AVERAGEX ? Why do you need to count?