Forum Discussion
VAR formula error
There is several errors in your formula - parenthesis in wrong places, and your first FORMAT is missing a second parameter. I have cleaned the parenthesis, but you still need to change your FORMAT to what ever you are trying to do.
LocationCounts = VAR Final_Total = IF( CALCULATE( COUNTA(Case_Data[Location]) ) = BLANK(), 0, CALCULATE( COUNTA(Case_Data[Location]) ) ) VAR Current_Category = CALCULATE( SELECTEDVALUE(Case_Data[Location]), ALLEXCEPT(Case_Data, Case_Data[Location]) ) RETURN IF( Current_Category = BLANK(), FORMAT(Final_Total), FORMAT(Final_Total, "0") )
Could you provide a small sample dataset with the columns and datatypes you are using with this calc? So that I can have a closer look on that.
There is several errors in your formula - parenthesis in wrong places, and your first FORMAT is missing a second parameter. I have cleaned the parenthesis, but you still need to change your FORMAT to what ever you are trying to do.
LocationCounts = VAR Final_Total = IF( CALCULATE( COUNTA(Case_Data[Location]) ) = BLANK(), 0, CALCULATE( COUNTA(Case_Data[Location]) ) ) VAR Current_Category = CALCULATE( SELECTEDVALUE(Case_Data[Location]), ALLEXCEPT(Case_Data, Case_Data[Location]) ) RETURN IF( Current_Category = BLANK(), FORMAT(Final_Total), FORMAT(Final_Total, "0") )
You should try to use daxformatter when writing your DAX - formatting your DAX correctly will help you spot errors and also make your DAX much easier to read/understand when you have to look at it months later.