Forum Discussion

bob57's avatar
bob57
Helper IV
5 years ago
Solved

Date filter does not propagate through data model.

I find myself once again leaning on this community, for which I am grateful. The "Weekly Status" table (shown below) performs as expected, when I select a week start date from the Date filter, but t...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi bob57 ,

     

    As there are 2 many-1 relationships between table Project,Time sheets and Dates,it is difficult to identify the relationships among the 3 tables:

     

    That is why when you filter data among the 3 tables,you see nothing changed.

    You need to create a measure as below:

    _log date = 
var _table=CALCULATETABLE(VALUES(Dates[Date]),FILTER(ALL('Dates'),'Dates'[Week Start Date]=SELECTEDVALUE('Weekly Status'[Week Starting])))
Return
IF(MAX('Time Sheets'[Logged Date]) in _table,MAX('Time Sheets'[Logged Date]),BLANK())

    Finally you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

bob57's avatar
bob57
Helper IV
5 years ago

This did not appear in the original post. Sorry.

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    Hi bob57 ,

     

    As there are 2 many-1 relationships between table Project,Time sheets and Dates,it is difficult to identify the relationships among the 3 tables:

     

    That is why when you filter data among the 3 tables,you see nothing changed.

    You need to create a measure as below:

    _log date = 
var _table=CALCULATETABLE(VALUES(Dates[Date]),FILTER(ALL('Dates'),'Dates'[Week Start Date]=SELECTEDVALUE('Weekly Status'[Week Starting])))
Return
IF(MAX('Time Sheets'[Logged Date]) in _table,MAX('Time Sheets'[Logged Date]),BLANK())

    Finally you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

    • bob57's avatar
      bob57
      Helper IV
      5 years ago

      Kelly,

      This worked for me and I learned something new about relationships. Thank you for your time and effort.

      Bob