Average Vs AverageA

[POWER_TESTING]

Hi Experts,

I'm facing problem with Average and AverageA.

Please can you clarify on this,....

I have one table..  (in my table i have True/False and null data aswell)

Table:

DATA

1

5

9

TRUE

FALSE

7

Average:

simple expression AVERAGE('Table'[DATA]), showing error.

Average should be 22/4= 5.5.

AverageA:  should be 23/6 = 3.833 because True as 1 and False as 0.

but my AverageA showing zero.

Thanks in Advance.....!

[Anonymous]

average and averageA are working same now 

No difference at all

[Greg_Deckler]

Just to follow-up on this, I took the table from:

https://msdn.microsoft.com/en-us/library/ee634809.aspx

And created a column:

AverageAColumn = AVERAGEA([Amount])

Everything came back as 0, so something is definitely amiss. I think you should submit this as an Issue or Bug.

[Greg_Deckler]

What is likely happening here is that your field is formatted as Text. AVERAGE is going to cause an error because it only handles numeric values. AVERAGEA is apparently not living up to its documentation. I removed all of the text values except the numeric text values it and it still gives an average of 0. Soooo...that should not be happening according to the documentation. By the way, I am thinking that your TRUE and FALSE values in a text field would both be counted as 0 (non-numeric text) versus 1 and 0. But who knows because non of it seems to be working correctly.

[POWER_TESTING]

Thank you, just few days back started work Powe BI.

Actually function wise i'm testing.... COUNT everyone knows number of records, 

just checking COUNTA, COUNTX and COUNTAX like.....  everything seems to be same result... 

These functions working perfect in Excel spread sheet, but not in Power BI.