AVERAGEA function not working properly

[POWER_TESTING]

Hi,

as per this link https://msdn.microsoft.com/en-us/library/ee634809.aspx, not working properly.

below example, 

Table:

DATA

1

5

9

TRUE

FALSE

7

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

but my AverageA showing zero.

Note: as per this site https://msdn.microsoft.com/en-us/library, i have find many issues.

same data for COUNT, COUNTA, COUNTX, COUNTAX also giving same result six(6)... (please can you check these as well)

Please assist this...

Thanks in Advance...!!!

[v-qiuyu-msft]

Hi @POWER_TESTING,

I have reported the issue regarding the AVERAGE function internally: CRI 54664218. Will update here once I get any information. 

---

 Note: as per this site https://msdn.microsoft.com/en-us/library, i have find many issues.

same data for COUNT, COUNTA, COUNTX, COUNTAX also giving same result six(6)... (please can you check these as well)

---

These functions COUNT, COUNTA, COUNTX, COUNTAX  should return 6 based on the sample data. Could you share more information about your concern? Thanks. 

Best Regards,
Qiuyun Yu 

[v-qiuyu-msft]

Hi @POWER_TESTING,

I got information internally below: 

This is by design. The column the customer entered has strings, so the whole column is a string column (customer can check column data type is "Text"), and all the aggregation rules applies as if everything is string, including numbers and TRUE/FALSEs. The documentation is talking about the case where the column is variant, where PBI Desktop does not support for now.

Best Regards,
Qiuyun Yu