topic Re: Relation problem in Developer

Relation problem

Analitika — Fri, 26 Feb 2021 07:28:04 GMT

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?

Re: Relation problem

lbendlin — Wed, 24 Feb 2021 01:16:43 GMT

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.

Re: Relation problem

v-lionel-msft — Fri, 26 Feb 2021 09:32:43 GMT

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.

Re: Relation problem

Analitika — Fri, 26 Feb 2021 07:29:02 GMT

v-lionel-msft Please remove data source