Data Missing When Filtering

Hi, tktmastr 

Based on your description, i created data to reproduce your scenario. Actually, the result is not associated with the order of filters. Even though the orders of filters differ from each other, the results are the same.

You can try to use a step which includes three filters. You can click ‘Edit Query’, go to Query Editor=>Query Settings, right-click the last step, choose ‘Insert Step After’.

Then insert the formula into the step.

     Table.SelectRows(#"Added Item", each [Date] = #date(2019,12,3) and Text.Contains([Page],"ccauth") and [Event Action] = "TM PV")

If it still receives the wrong result, maybe there is something wrong in other steps. If I misunderstand your thoughts, please show us your sample data. I am glad to solve the problem for you.

Best Regards,

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.