In the Dataset editor SQL is used, in the Chart designer – MDX.
Go here to learn more info about calculations.