topic Re: Measure not recognizing columns in DAX Commands and Tips

Measure not recognizing columns

Nigel29 — Fri, 27 May 2022 08:24:59 GMT

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.

Re: Measure not recognizing columns

SpartaBI — Fri, 27 May 2022 09:37:00 GMT

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 🙂

Re: Measure not recognizing columns

Nigel29 — Fri, 27 May 2022 11:22:41 GMT

Would I need to alter the formula for it by affected by dates on a splicer

Re: Measure not recognizing columns

SpartaBI — Fri, 27 May 2022 11:25:23 GMT

Nigel29 It will pick up any filter in the way I wrote you.

There is no calculate their that change the filter context

Re: Measure not recognizing columns

Nigel29 — Fri, 27 May 2022 11:40:13 GMT

Thank you very much.

Re: Measure not recognizing columns

SpartaBI — Fri, 27 May 2022 11:42:14 GMT

Nigel29 my pleasure 🙂
Hey, check out my showcase report:
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up over there if you liked it 🙂