Creating matrix visual with certain values having a different formula

[bastianki]

Hi everyone

I have created a matrix visual in the below format

Service Line	Hours	Revenue	Cost	RPH	CPH
Category 1
Actual	613	63111	38596	102.9543	62.96248
Budget	1741	28470	39685	16.35267	22.79437
Estimate	741	27470	38685	37.07152	52.20648
Forecast	1354	90581	77281	66.89882	57.07607
Variance	387	-62111	-37596	zzzz	zzzz
Category 2
Actual
Budget
Estimate
Forecast
Variance
Category 3
Actual
Budget
Estimate
Forecast
Variance

RPH = Revenue / Hours

CPH = Cost / Hours

Variance = Budget - Forecast

The rows Actual, Estimate, Budget, Forecast and Variance is coming from the table loaded via PowerQuery and hence all calculations are done in powerquery and it comes correctly. RPH and CPH are measures. Hence, when it comes to Variance of the measures RPH and CPH, the answer would be incorrect in those two highlighted cells.

Is there a way to make amendments to those two cell calculations alone?

[bastianki]

Hello all

I could tweak the settings by conditionally formatting the last two columns for all rows where Variance appears - I made the font color same as background color and made it invisible.

Is there any other alternate solution available.?