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.