Forum Discussion
Anonymous
8 years agoNot applicable
VAR formula error
Hi Experts I am trying to write the following VAR formula but keep on getting an error, cannot see the wood for the trees.... HELP LocationCount = VAR Final_Total = IF(CALCULATE(COUNTA(Case_...
- 8 years ago
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") )
sdjensen
8 years agoSolution Sage
Anonymous - the tip was ment for Anonymous. You seem to understand the DAX :)
Anonymous
8 years agoNot applicable
All (experts)
many thanks for the excellent feedback and support....