Cross Table Calculations

Hi  87Happy ,

Do you use the FLAG function to filter? The specific usage method is as follows:

(1)Create a  measure

FLAG = 
VAR _CITY = MAX('Table 1 - Release'[CITY])
VAR _SIZE = MAX('Table 1 - Release'[TRAILER SIZE])
VAR _START = MAX('Table 1 - Release'[START OF APPT])
VAR _END = MAX('Table 1 - Release'[END OF APPT])
RETURN IF(MAX('Table 2 - Empty'[CITY])=_CITY && MAX('Table 2 - Empty'[TRAILER SIZE])=_SIZE && MAX('Table 2 - Empty'[START OF APPT])>=_START && MAX('Table 2 - Empty'[END OF APPT])<=_END,1,0)

(2)Apply filtering

I included this function in the file I replied to last time, if this doesn't solve your question, please upload the sample file. I was able to filter out the values normally in the previous example file

Best Regards,
Gallen Luo