Measures

[Anonymous]

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

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

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

[AlB]

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