Forum Discussion
ALLEXCEPT in a Measure vs Calculated Column
I'm really hoping someone can help me here. I want to create a dynamic chart based on a count of products during a specific time that shows me the top 5 and puts the rest into an "Others" category. ...
Your exactly right.
A calculated column is process (calculated) when you refresh the data into the data model. After that the data is static, it wont change regardless of how you filter your report. As a result the ranking is operating over all the data in your table.
A measure on the other hand calculates at run time (when you interact with the report) . In this the scenerio it takes into account the filters you have on your dashboard as well as any filters you apply in your measure itself. As a result it will take into account the data filters that you have selected.
So is there any way to take the "Product Chart" measure in the left most table and use that as a legend or axis on a chart that changes depending on the dates selected?