Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Dynamically calculate Measure value based on Slicer Selection

Hi, My requirement is create measure which calculate distinct count of rows and i have one date column which i need to check with user selected Date slicer.   CONTROL PROVIDERS = CALCULATE(DISTIN...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    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.

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    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.

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

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.