Hi, I am relatively new to Power BI
Question : why won't this DAX works in Power BI?
LA Profit =
VAR LACost
CALCULATE([Total Cost],Locations[Location ID]="A132"
VAR LASales
CALCULATE([Total Sales],Locations[Location ID]="A132"
RETURN
It says "The syntax for 'CALCULATE' is incorrect. (DAX(VAR LACost CALCULATE([Total Cost],Locations[Location ID]="A132"VAR LASales CALCULATE([Total Sales],Locations[Location ID]="A132"RETURN))."
Question : why won't this DAX works in Power BI?
LA Profit =
VAR LACost
CALCULATE([Total Cost],Locations[Location ID]="A132"
VAR LASales
CALCULATE([Total Sales],Locations[Location ID]="A132"
RETURN
It says "The syntax for 'CALCULATE' is incorrect. (DAX(VAR LACost CALCULATE([Total Cost],Locations[Location ID]="A132"VAR LASales CALCULATE([Total Sales],Locations[Location ID]="A132"RETURN))."