Relation problem

[Analitika]

i have relations

Graph should show me last table value on change date on slicer

But if related partners_trans and calendar it work wrong, if no relation between tables graph work like excpected, but then not work date slicer (no reaction on change)

How fix this issue?

[v-lionel-msft · Accepted solution]

Hi @Analitika ,

Is this what you want?

Please refer to my .pbix file.

I don't particularly understand why you need to create such a line chart. According to your formula, the data displayed by the falling line chart is meaningful.

Best regards,
Lionel Chen

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

[Analitika]

@v-lionel-msft  Please remove data source

[lbendlin]

Your _payed and _sum measures have a dependency on the calendar table, but your calendar table is also connected to the document date column.  

You can't really have both - either you use the data model, or you use an unconnected calendar table to feed the slicer.