Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HOW TO SUM A EXPRESSION

Hi I have to expression salesT = sum(sales) and CostT ) = sum(cost), with this two expression, i calculated ratio = CostT/salesT.    I need to know how to sum(ratio)  as a individual value, i need ...
DAX
DAX. CALCULATE
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

I am not sure I got it completely.

 

I think Ratio should be calculated like 

Ratio = calculate(divide(sum(sales),sum(cost))

It will calculate is at all level.

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.