This category is the closest I could find for my question.
I just attended Sam’s “Advanced DAX Combinations” series of lectures.
I have a question regarding the “How to Segment Your Data Based on Any Measure” video.
Sam uses measures to add columns to the Regions lookup table for City Sales Rank and Total Sales per City.
Wouldn’t the data in these columns become stale over time? Would the measure need to be invoked after each refresh of data?
Can the same purpose be achieved by dynamically in a measure using VARs for the City Sales Rank and Total Sales per city?