Forum Discussion
Measure not recognizing columns
I'm new to Power BI and have really been struggling with these DAX formulas. I've been trying to do gross profit margin as a new measure but it seems the columns are not being recognised and I can't figure out why or where I went wrong.
Nigel29 you can't reference a "naked" column in a measure without first supplying to it a row context (in most cases the straight forward solution is just wrap it up with an aggregation function). In your case you just need to add an aggregation, probably SUM.
So write: DIVIDE (SUM('Table'[Column1]),SUM('Table'[Column2]))
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.Showcase Report – Contoso By SpartaBI
Check it out! Give it a thumbs up if you liked it 🙂
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
SpartaBI Logo
5 Replies
- SpartaBI
Community Champion
Nigel29 you can't reference a "naked" column in a measure without first supplying to it a row context (in most cases the straight forward solution is just wrap it up with an aggregation function). In your case you just need to add an aggregation, probably SUM.
So write: DIVIDE (SUM('Table'[Column1]),SUM('Table'[Column2]))
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.Showcase Report – Contoso By SpartaBI
Check it out! Give it a thumbs up if you liked it 🙂
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
SpartaBI Logo
