Forum Discussion

bigk's avatar
bigk
Icon for Helper III rankHelper III
2 years ago
Solved

Calculated measure based on date from related table

Hello folks   I’ve run into problems with calculated measures. I have 3 tables with meeting dates, projects and tasks. The relationship is one-to-many in the following path - Meeting dates->Projec...
Need Help
  • bigk's avatar
    bigk
    2 years ago

    I ended up redesigning my query and tables so this is not valid anymore.

bigk's avatar
bigk
Icon for Helper III rankHelper III
2 years ago

Hello, rajendraongole1 

Thanks for very quick response. I've tried your suggestions. First of all i think that relationship between meeting dates table and tasks should be present based on your suggestions. So i've made it.

 

But unfortunately i'm not getting any results if i report it on meeting date level or on project level.

 

  • rajendraongole1's avatar
    rajendraongole1
    Icon for Super User rankSuper User
    2 years ago

    Hi bigk - Ok, can you try the below measure with out using the userrelationship function to get the

    completed tasks between the previous and current meeting dates.

     

    Completed Tasks =
    VAR CurrentMeetingDate = SELECTEDVALUE('Meeting Dates'[Meeting Date])
    VAR PreviousMeetingDate =
    CALCULATE(
    MAX('Meeting Dates'[Meeting Date]),
    FILTER(
    ALL('Meeting Dates'),
    'Meeting Dates'[Meeting Date] < CurrentMeetingDate
    )
    )
    RETURN
    CALCULATE(
    COUNTROWS('Tasks'),
    FILTER(
    'Tasks',
    'Tasks'[Completion Date] > PreviousMeetingDate &&
    'Tasks'[Completion Date] <= CurrentMeetingDate
    )
    )

     

    Hope it works

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!