DAX Average Excluding Zero-"The end of the input was reached"

[amirhabshush]

Hello, 

im trying to use this formula-

Average of SD Covered = CALCULATE( AVERAGE('Table1 (2)'[SD Covered (m) [> 5.5(m/s)]]), FILTER('Table1 (2)', 'Table1 (2)'[SD Covered (m) [> 5.5(m/s)]])<> 0 ))

but for some reason the warning "The end of the input was reached" is shown.

Can someone please help?

thanks!

[Anonymous]

Hi @amirhabshush 

You typed an extra bracket here. 

This error usually comes when you're missing a close parenthesis or you have too many, or some other punctuation mistake.

Regards,

Aditya

[amirhabshush]

Thanks a lot for your answer Aditya @Anonymous ,

But unfortunately this bracket is a part of the value itself.

I still tried to do what you said but the following error occured:

The syntax for ')' is incorrect. (DAX(CALCULATE( AVERAGE('Table1 (2)'[SD Covered (m) [> 5.5(m/s)]), FILTER('Table1 (2)', 'Table1 (2)'[SD Covered (m) [> 5.5(m/s)])<> 0 )))).

[Anonymous]

I pointed at the round bracket, not the square bracket, what I meant is this :

Average of SD Covered = CALCULATE( AVERAGE('Table1 (2)'[SD Covered (m) [> 5.5(m/s)]]), FILTER('Table1 (2)', 'Table1 (2)'[SD Covered (m) [> 5.5(m/s)]]<> 0 ))

 Let me know if this gives the required result

[amirhabshush]

hi again @Anonymous,

it still doesn't work

Average of SD Covered = CALCULATE( AVERAGE('Table1 (2)'[SD Covered (m) [> 5.5(m/s)]], FILTER('Table1 (2)', 'Table1 (2)'[SD Covered (m) [> 5.5(m/s)]]<> 0 )))

the last Parenthesis appear automatically once i click on the v.

[Anonymous · Accepted solution]

I took some dummy data and deduced the column name and table name from the dax you gave. As you can see, I get the correct result for the dummy data.

Regards,

Aditya

[Anonymous]

Hi @amirhabshush, please try this, sorry for the inconvenience 

Average of SD Covered = CALCULATE( AVERAGE('Table1 (2)'[SD Covered (m) [> 5.5(m/s)]]]), FILTER('Table1 (2)', 'Table1 (2)'[SD Covered (m) [> 5.5(m/s)]]]<> 0 ))

 This seems to work in my system. It would be helpful if you could give some sample data with table name and column name. 

[amirhabshush]

Hi @Anonymous it worked!

thank you very much for your kind help!

[Anonymous]

Hi @amirhabshush , you are welcome, I'm glad that it worked! It would mean a lot to me if you could accept my reply as a solution.

Regards,

Aditya