Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?....
My pbix file got corrupt, hence I got that error...thanks....
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.
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.