topic Circular Dependency on column from measure in DAX Commands and Tips

Circular Dependency on column from measure

mbsmeltzer — Sat, 15 Jun 2024 21:04:47 GMT

I see other posts regarding the subject but my lack of skills is making it feel overwhelming...

I'm trying to create multiple columns each from a Measure but as I create the 2nd one I get a circular reference. It feels crazy that I have to create one thing for the measure then one thing to turn that measure into an actual column, then a third thing to properly format that column, but here I am.

Can someone show me how I can create multiple columns in the same table each referencing a different Measure? or better yet, how I can accomplish all three of those things in one step - a measure that is properly formatted and displayed in a column. Thank you!

Click here to access the file from my Drive

Re: Circular Dependency on column from measure

MattAllington — Sat, 15 Jun 2024 21:53:41 GMT

you are using the wrong approach. Read my article here https://exceleratorbi.com.au/calculated-columns-vs-measures-dax/

the reason it doesn't work is complex and probably not as important as knowing you simply shouldn't do it.

one of the key concepts you need to learn (and follow) is a process on how to write measures. I argue the reason beginners write calculated columns and not measures is because with a calculated column you can "see" the data. You need to set up the same feedback loop for measures. Always do this

go to a new blank report page (sheet in Excel)
add a matrix (pivot table in Excel)
Add something meaningful into rows on the visual. Something that should respond to/change with your measure
Write the measure and add it to the visual.
don't try to boil the ocean. Write part of the "solution" and check it is working before proceeding.

Re: Circular Dependency on column from measure

AntrikshSharma — Sun, 16 Jun 2024 06:06:16 GMT

mbsmeltzer Read this: https://www.antmanbi.com/post/circular-dependency-between-calculated-columns-in-a-table