Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

New Member

var measure result incorrect

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






 thank you everyone




Super User
Super User

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

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors