Forum Discussion
Help with relationships
- 7 years ago
Hey,
I guess you are looking for a measure like this:
Measure =
CALCULATE(
SUM('Invoice'[[Invoice]] Amount])
, CROSSFILTER('Job List'[[Job]] Job No.] , 'Time'[[Job]] Job No.] , Both)
)
Using CROSSFILTER allows to avoid many-to-many relationships, but still provides the possibility to use the filter direction "Both".
This allows to create something like this:
But, I'm not sure how you want to treat the fact, that Brenton and Chris have worked on job number "1901-0001" and for this reason the measure shows the same value. But this is not an issue of the measure, but this is due to data distribution. Of course this can be used to calculate some kind of "share".
Hopefully this is what you are looking.
Regards,
Tom
I am struggling to apply this to my model. I want the column "invoiced Amount total" from table "Invoiced Time Report" to propogate in the lower visual combined with the table "Workflow Time Report". Getting this same result everywhich way I try to do this. ?????
My cross filter measure is
Inv Time measure 2 = CALCULATE(SUM('Invoiced Time Report'[[Task]] Amount]) , CROSSFILTER('Job List'[Job No.] ,'Workflow Time Report'[[Job]] Job No.], Both) )