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

October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more

Reply
Anonymous
Not applicable

DAX query

Hi all,
 
This is the DAX query I have written.
 
Value = var m = (calculate(SUM('Table'[A]),FILTER('Table','Table'[B] = "0")))
 
But I still get an error, The syntax for ')' is incorrect. I am not sure what the problem is. Can I please know what is incorrect?
 
Any help is appreciated!
 
Thank you!
Megha
 
1 ACCEPTED SOLUTION
danextian
Super User
Super User

Hi @Anonymous ,

 

When using VAR, RETURN is required to return the final value/formula you want. You can write your formula as below

Value =
VAR m =
     CALCULATE ( SUM ( 'Table'[A] ), FILTER ( 'Table', 'Table'[B] = "0" ) ) 
RETURN
    m

 

or simply 

Value =
CALCULATE ( SUM ( 'Table'[A] ), FILTER ( 'Table', 'Table'[B] = "0" ) )

 

By the way in case you are not aware 0 is different from "0" as the latter (in double quotes) is a text string.










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

1 REPLY 1
danextian
Super User
Super User

Hi @Anonymous ,

 

When using VAR, RETURN is required to return the final value/formula you want. You can write your formula as below

Value =
VAR m =
     CALCULATE ( SUM ( 'Table'[A] ), FILTER ( 'Table', 'Table'[B] = "0" ) ) 
RETURN
    m

 

or simply 

Value =
CALCULATE ( SUM ( 'Table'[A] ), FILTER ( 'Table', 'Table'[B] = "0" ) )

 

By the way in case you are not aware 0 is different from "0" as the latter (in double quotes) is a text string.










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.