DAX Crossfilter

[Anonymous]

Hey, could you help with new function that i m using, crossfilter.  Red text is a part of original formula, black is an addition with crossfilter. My model works with bi directional relation.

crossfilter tscan =

VAR Test =

    FILTER ( TJob, TJob[SekundærNavn] = "Testing")

RETURN

    CALCULATE( DIVIDE ( SUMX ( Test, TJob[FirstPassQty] ), SUMX ( Test, TJob[Antal] ) ),CROSSFILTER(TJob[ID],TScan[RefID], Both))

Tscan has name filter that i want to apply on chart

[Anonymous]

ref

[Anonymous]

https://drive.google.com/file/d/1j1mmGwl4hEeruCdLLvvcOPOsO6R6FlHr/view?usp=sharing

[Anonymous]

Hi @Anonymous ,

Please share some sample data so that we could test the formula.

Best Regards,

Jay

[Anonymous]

ref