Forum Discussion
Measure not recognizing columns
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
Community ChampionNigel29 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
Would I need to alter the formula for it by affected by dates on a splicer
- SpartaBI
Nigel29 It will pick up any filter in the way I wrote you.
There is no calculate their that change the filter context
Thank you very much.
- SpartaBI
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 🙂