topic Adding two measure totals from the same table in DAX Commands and Tips

Adding two measure totals from the same table

CZMIU_cvazquez — Wed, 12 Oct 2022 14:50:31 GMT

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

Re: Adding two measure totals from the same table

Shaurya — Wed, 12 Oct 2022 20:42:31 GMT

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:

Re: Adding two measure totals from the same table

CZMIU_cvazquez — Tue, 18 Oct 2022 14:06:36 GMT

I was able to resolve the issue with the following