Forum Discussion

dmelton's avatar
dmelton
Regular Visitor
6 years ago
Solved

Measure Not Passing Through Date Slicer Value

Let me just preface with the fact that this is my first PowerBI dashboard. I have since realized that I did not set up my data model in the optimal way. A solution is to create a relationship to my c...
Need Help
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    Try storing your slicer values as variables first.

     

    Inquiry Dateslicer = 
var mindate = [DateSlicerMin]
var maxdate = [DateSlicerMax]
Return 
CALCULATE(DISTINCTCOUNT('Campaign_Member_Contacts'[LookupID]),
                            FILTER('Campaign_Member_Contacts',
                                ('Campaign_Member_Contacts'[FirstRespondedDate] >= mindate && 'Campaign_Member_Contacts'[FirstRespondedDate] <= maxdate)
                                )
                            )

     

    If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Try storing your slicer values as variables first.

 

Inquiry Dateslicer = 
var mindate = [DateSlicerMin]
var maxdate = [DateSlicerMax]
Return 
CALCULATE(DISTINCTCOUNT('Campaign_Member_Contacts'[LookupID]),
                            FILTER('Campaign_Member_Contacts',
                                ('Campaign_Member_Contacts'[FirstRespondedDate] >= mindate && 'Campaign_Member_Contacts'[FirstRespondedDate] <= maxdate)
                                )
                            )

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

dmelton's avatar
dmelton
Regular Visitor
6 years ago

This works, (but unfortunately will still require me to edit all my measures that use the DateSlicerMin/Max). Will still mark as solution.

 

This is good to know for nesting with more complex measures. Thanks!