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

SpartaBI
4 years ago
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]))

Showcase Report – Contoso By SpartaBI
Check it out! Give it a thumbs up if you liked it 🙂

Forum Discussion

Measure not recognizing columns

Related content

Measure not recognizing columns

Measure not recognizing table field

Measure two columns

TOTALWTD not recognizing Calendar

DATEDIFF not recognizing a column