DAX: Unwanted cartesian product lines?
Please help to calculate/understand properly lastDate and rankDate measures for following simplified example (download) : Desired result: Reality (incorrect subtypes): Why relationship is broken? How to avoid this cartesian product lines? My Measure (I commented workaround, because it's kind of postfilter, not prefilter): rnkDate = VAR t = CALCULATETABLE( VALUES(tstTable[Date]), REMOVEFILTERS(tstTable[Date]) ) RETURN //IF( MAX(tstTable[Amount])<>BLANK(), // WORKAROUND To hide unwantedd rows RANKX( t, LASTDATE(tstTable[Date]) ) //) P.S. Mess happens only if I use fields from dimensional table dimType[Type] (within one table everything is Ok):
