Forum Discussion

powerbr's avatar
powerbr
Frequent Visitor
5 years ago
Solved

Using a CALCULATE measure to aggregate with dynamic dates

Hi all,   When I started working on this I thought it would be simple, however, it is taking a toll on me. This is my problem:   I have this data-model, which combines three tables.   I ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi powerbr ,

     

    If you want to use SELECTEDVALUE(DimInstance_Projects[CutDate]) as the filter result of the slicer, there must be no relationship between your DimInstance_Projects table and the FactProjExp table.

     

    If you want to add up the values on April 5, 2021, you can add the equal sign.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi powerbr ,

 

If you want to use SELECTEDVALUE(DimInstance_Projects[CutDate]) as the filter result of the slicer, there must be no relationship between your DimInstance_Projects table and the FactProjExp table.

 

If you want to add up the values on April 5, 2021, you can add the equal sign.

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

powerbr's avatar
powerbr
Frequent Visitor
5 years ago

Thanks, this works.

 

I am marking this down as a solution.

I have a doubt, if I create a relationship but it only filters one way (Ideally, I want to filter those tables as well based on dates), will this have an impact?
I am going to be trying this.

Doing this task made me learn lots about PBI, much appreciated.