Unable to filter my dataset in Power BI

[pavanmanideep]

Hi Folks,

I am trying this since 4 hours, but still stuck with my simple dax calculation, this doesnt work for me, I am very new to Power BI and trying out to filter my existing table in the dataset using below simple expression by creating a new table, but could't get it through. Can someone point out what this error below mean?....

[pavanmanideep]

My pbix file got corrupt, hence I got that error...thanks....

[vicky_]

Hello. 
The error message is telling you that the result of your calculation is a column / table. In most cases, the FILTER() function will be used with the CALCULATE() function, something like:

CALCULATE(SUM([sales]), FILTER(contact, contact[age] > 40))

 The function above (assuming you have a sales column somewhere) will return the Sales for all contacts with age > 40. Depending on your purposes, you will need to replace SUM([sales]) with whatever you are trying to calculate. 

[FreemanZ]

create a table with the same code. you are creating a column. 

[pavanmanideep]

Ok, I get this when I use same query to create a table...I dont have any clue.