Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

DAX Crossfilter

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