Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
texasmcse
Frequent Visitor

DAX query works in PBI Desktop, not in DAX Studio

Trying to use DAX Studio to learn DAX.  I have queries (like below) that work as a measure in the PBI desktop app but always return syntax errors in DAX studio.  DAX studio is referencing the same PBIX.  I would appreciate any info on what I'm doing wrong.  
 
test = COUNTROWS (    
    SUMMARIZECOLUMNS(
MECM[OS],
    KEEPFILTERS( FILTER(ALL(MECM[OS]),
    SEARCH( "Windows", MECM[OS], 1, 0 ) >= 1 )))
)    
 
daxstudioq.png
1 ACCEPTED SOLUTION
Anonymous
Not applicable

Using DAX Studio requires the EVALUATE statement at the beginning of each query that you excecute. Additionally only queries that return a table is valid, so if you wish to test a measure that return a scalar value you could return the result in a table using a syntax like this:

 

EVALUATE

{"Result", COUNTROWS(.....)}

 

Br,

Magnus

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Using DAX Studio requires the EVALUATE statement at the beginning of each query that you excecute. Additionally only queries that return a table is valid, so if you wish to test a measure that return a scalar value you could return the result in a table using a syntax like this:

 

EVALUATE

{"Result", COUNTROWS(.....)}

 

Br,

Magnus

Helpful resources

Announcements
November Fabric Update Carousel

Fabric Monthly Update - November 2025

Check out the November 2025 Fabric update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Users online (25)