Forum Discussion

anandfarmers's avatar
anandfarmers
Icon for Advocate I rankAdvocate I
2 years ago

ALLSELECTED() - data modelling issue

Hi All,   I have the below schema   The DatePeriod can be Yesterday, This Week, This Month, etc. So a Date can be in multiple Date Periods.  Date Period has Many to One relationship with D...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago
Date Period has Many to One relationship with DimDate.

yes, but the search filter goes both ways, making this rather ineffective.  Cut the link and use measures instead.

  • anandfarmers's avatar
    anandfarmers
    Icon for Advocate I rankAdvocate I
    2 years ago

    Thanks lbendlin .

    The users need to be able to filter by Date Period. e.g. This week, this month, etc. So they don't need to enter dates - that is the requirement.

    I cannot use a measure as a Slicer.