Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Measures

Hi ALl,

 

I am a beginner and was trying to work out a new measure by subtracting 2 measures. To elaborate, I have a tab "Revenue" wherein i have calculated "total Revenue" measure. Similarly, another tab "COS" wherein i have calculated "total Cost". I want to compute Gross profit, but the calculation is not correctly showing the right numbers.  

So my query is , can we write a measure between 2 measures:

aka "Total Rev" - "total Cost" = Gross profit

Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    You need to edit the relationship between two tables. Then you can subtract these two measures to get correct results.

     

2 Replies

  • AlB's avatar
    AlB
    Community Champion
    6 years ago

    Hi Anonymous 

    Sure you can but you have to reference the mesures in the right fiormat, not with "" 

    Gross profit = [Total Rev] - [total Cost]

     

    Please mark the question solved when we get to the solution and consider kudoing if posts are helpful.

    Cheers  Datanaut

     

     

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    You need to edit the relationship between two tables. Then you can subtract these two measures to get correct results.