Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Unable to filter my dataset in Power BI

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?....



Frequent Visitor

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

Solution Sage
Solution Sage

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. 

Community Champion
Community Champion

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

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



Helpful resources

Vote for T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors