Adding two measure totals from the same table

[CZMIU_cvazquez]

Dear all,

I’m desperately looking for advise on how to add two separate calculation totals into one, from the same table.

With that said, I’m trying to determine the “Overall Need”, contract capture volume, based on the number of addressable iBases and the contracts that have already been acquired.  There are two different Target KPIs.  The Warranty Target is 30% and the Renewal Target is 78%. 

Please any assistance would be greatly appreciated.

Supporting measures are as follows:

** Device Count **

** Future Contracts **

* Condition needed because in case the contract acquisition is higher than the target

[CZMIU_cvazquez · Accepted solution]

I was able to resolve the issue with the following

[Shaurya]

Hi @CZMIU_cvazquez,

I see that you have created measures for these operations but you need these calculations done on a row level. Your measures are aggregating the numbers first and then doing the subtraction and multiplication. I suggest that you use these formulas to create a Calculated Column. That should give you the right numbers.

Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: Forecast Period - Graphical Comparison