Forum Discussion
Measures vs Calculated Columns
Question… I have a table that I summarized using my Calendar Table and then layering in calculations from related tables.
Summarize(Calendar, BOM, EOM, WeekBeginning, WeekEnding, WeekNo. “TotalOfWidgetsTable1”, Calculated(Count(WidgetId),Fitler(Table1,WidgetCreatedDate>=WeekEnding)),
“TotalOfWidgetsTable2”, Calculated(Count(WidgetId),Fitler(Table2,WidgetCreatedDate>=Weekending))
)
This seems to calculate the total widgets for both tables for each week, but when I compare these totals to say a measure the calculates the same value, the values form the summary table are much lower. Curious as to why? Are they not essentially do the same thing?
Hi Anonymous ,
Be aeware that measures and calculated columns are different, especiually in context the columns are calculated based on the row context of a table, altough you can change it, the calculation will be the result of the row context.
Measure are based on the full context of the measure and where it is used, so depeding if you use a chart, a card, filtering and so on you can get different results. Check the blog post below with the differences.
2 Replies
Hi Anonymous ,
Be aeware that measures and calculated columns are different, especiually in context the columns are calculated based on the row context of a table, altough you can change it, the calculation will be the result of the row context.
Measure are based on the full context of the measure and where it is used, so depeding if you use a chart, a card, filtering and so on you can get different results. Check the blog post below with the differences.
Hi Anonymous ,
You could read the following article to learn the different between calculated columns and measures:
calculated-columns-and-measures-in-dax
Wish it is helpful for you!
Best Regards
Lucien
