Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
pavanmanideep
Helper III
Helper III

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

pavanmanideep_0-1669953960524.png

 

4 REPLIES 4
pavanmanideep
Helper III
Helper III

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

vicky_
Super User
Super User

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
Super User
Super User

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.

pavanmanideep_0-1669955861284.png

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.