Forum Discussion

fordmichael20's avatar
fordmichael20
Frequent Visitor
9 years ago

Measures Contain Different Values on Table View and Visual View

Hi,   I'm using the dates from a transaction table as measures and then using them in my column. My measures look good in the visual view, I've called them RD1 and RD2 based on a column "RD". Howev...
Need Help
v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

fordmichael20,

 

This is the difference between calculated measure and calculated column.

Calculated columns (and tables) are:

- Evaluated for each row in your table, immediately after you hit 'Enter' to complete the formula

- Saved back into the model so take up space

 

Calculated Measures are:

- Evaluated when you use it in a visual, when the visual is rendered

- Not saved anywhere (well, actually there's a cache in the report layer but it's not part of the file when you hit Save)

 

Please refer to the link below to see the details.
http://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
https://projectbotticelli.com/knowledge/dax-calculated-columns-vs-measures-video-tutorial

 

Regards,
Charlie Liao

fordmichael20's avatar
fordmichael20
Frequent Visitor
9 years ago

v-caliao-msft

Thanks for the feedback.

 

Do you have any recommendation for how to take a value defined in a visual and using it in a column calculation then? Or is this not something Power BI can do?