var measure result incorrect

[tarz]

Good morning everyone,

I have a small problem with a dax query. I should create a measure that makes certain calculations and to do this I have to create a table which I would then use as a filter for this measure by creating a variable. for this reason I am unable to use the SUMMARIZECOLUMN formula inside the measure since power bi does not accept it. My problem is that if I process the query using SUMMARIZE COLUMN I get some results (correct according to the customer), while if I process it using SUMMARIZE and then CALCULATETABLE I get others. In particular in the column/measurement I add "total_services" where I use the REMOVEFILTERS. Can anyone give me suggestions. Thank you all. I attach screenshots of the incorrect query with the results and of the correct one

incorrect

 

correct

 thank you everyone

[lbendlin]

use DAXDebugOutput and EVALUATEANDLOG() to troubleshoot your measure steps.