Budget: 200 UAH Deadline: 1 day
About 10k lines are processed in 1 minute. That is, with every change in the parameter, the query editor processes the data and not DAX.
I can look into your PowerBI file and analyze the written code. 500k+ line is nothing. The bet is conditional.