solving a query

[Nehu23]

Calculate(distinctcount('Call Center'[Call Id]),Filter('Call Center','Call Center'[Answered (Y/N)]="Y")) i have try so many time but showing error token literal expected please solve and ans me

[Anonymous]

Hi @Nehu23 ,

Calculate(distinctcount('Call Center'[Call Id]),Filter('Call Center','Call Center'[Answered (Y/N)]="Y")) 

The formula provided is a DAX formula. And the dax appears in Power BI Desktop instead of Power Query Editor. In Power Query, we often use M language. Here's the article about the differences between them. Please refer to

M or DAX? That is the Question! - RADACAD

About counting in Power Query, refer to

List.Count in Power Query: 10 examples - BI Off The Grid

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[Nathaniel_C]

Hi @Nehu23 ,
You have posted this in Power Query forum.  Is that where you are writing this code?
If not you would be better off posting this in the DAX forum.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel