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.
I have one particular report with only a few tables and I have been unable to create any measures because intellisense isn't bringing up any tables/fields and when I try to enter them manually I'm getting errors. I'm hoping this is something simple I'm overlooking.
Solved! Go to Solution.
You are getting that particular error message because DIVIDE in a measure requires expressions as arguments, not column references. So you need to do: DIVIDE ( SUM ( Table[Column1] ), SUM ( Table[Column2] ) ) or similar. Otherwise the function has no idea to which rows you are referring. Which is why intellisense fails. It is not allowed in that situation.
Hi @mterry
From your image it appears that the measure is incomplete.
But with that being said, I would suggest uninstalling Power BI Desktop, and then re-installing it from the download if that is where you originally installed it and see if that resovles your error
Here's a little more detail: I have two tables, one that shows actuals amount spent and one that shows budget. I have a matrix with one column showing the actuals and one showing the budget - the rows represent the location. There are also dates (earliest) being used as additional columns - both the initial planned date and the actual date. I'm trying to calculate the percentage of budget we're currently at - dividing the actuals by the original budget. Intellisense isn't bringing up the fields, when I type out the entire measure as shown below, I get the associated error. I don't fully understand the error as the 'Actuals' are in fact being summed.
You are getting that particular error message because DIVIDE in a measure requires expressions as arguments, not column references. So you need to do: DIVIDE ( SUM ( Table[Column1] ), SUM ( Table[Column2] ) ) or similar. Otherwise the function has no idea to which rows you are referring. Which is why intellisense fails. It is not allowed in that situation.
Thanks for explaining, that fixed it.
User | Count |
---|---|
139 | |
70 | |
68 | |
52 | |
52 |
User | Count |
---|---|
210 | |
92 | |
64 | |
59 | |
56 |