Forum Discussion
How find the most computation expensive calculated columns
So in the data model that I inherited, there are a number of calculated columns in the main table. By chance, I noticed if I delete this particular "end customer" column, it would cut the time to ope...
remember that EVALUATE must return a table. RELATED will always return a scalar value for a single column. You are mixing too many concepts at once.
Check your data model, then formulate the right DAX. You can also let the "DAX Query View" do the heavy lifting for you when you ask it to create the code for a calculated column or a measure etc.
the whole point of this exercise was to compare different columns and why some columns have a greater effect on the model efficiency/speed. The above logic is the correct DAX for my business case.