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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
165 | |
83 | |
68 | |
68 | |
59 |