Dynamically calculate Measure value based on Slicer Selection

Hi Anonymous ,

Did you create relationship between date table and the fact table in your scenario? Here I created a sample for your reference.

Measure = CALCULATE(DISTINCTCOUNT(NETWORK[Merged Colum]),FILTER('NETWORK','NETWORK'[EFFECTIVE_DT]<=SELECTEDVALUE('Date'[Date])))

Pbix as attached.

Hi,

Create a relationship from the EFFECTIVE_DT column to the Start Date column of the Date Table.  Create a slicer and drag Start Date column from the Date Table.  Select a Date there.  Write these measure

Count = DISTINCTCOUNT(NETWORK[Merged Colum])

CONTROL PROVIDERS = CALCULATE([Count],DATESBETWEEN('Date'[Start_Date],MINX(ALL(Date),'Date'[Start_Date]),MAX('Date'[Start_Date])))

Hope this helps.