DAX query

Question

Hi all,&nbsp;This is the DAX query I have written.&nbsp;Value = var m = (calculate(SUM('Table'[A]),FILTER('Table','Table'[B] = "0")))&nbsp;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?&nbsp;Any help is appreciated!&nbsp;Thank you!Megha&nbsp;

danextian · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;When using VAR, RETURN is required to return the final value/formula you want. You can write your formula as belowValue =
VAR m =
     CALCULATE ( SUM ( 'Table'[A] ), FILTER ( 'Table', 'Table'[B] = "0" ) ) 
RETURN
    m&nbsp;or simply&nbsp;Value =
CALCULATE ( SUM ( 'Table'[A] ), FILTER ( 'Table', 'Table'[B] = "0" ) )&nbsp;By the way in case you are not aware 0 is different from "0" as the latter (in double quotes) is a text string.

Forum Discussion

Related content

DAX Query help

Dax query dependency

DAX Query Format Date

Dax Queries for Open Close stock

DAX Query View