How to calculated difference value from fixed value

[hanami001]

Hello Everyone,

I have created the measure for calculating a difference value, but the value in column DiffPrices is not collect as below.

Please see column TG DiffPries (Red and Green highlighted), I want as this (PG DiffPrices - TG DiffPrices).

As below is the measure formula.

DiffPrices = 
VAR DiffPG = CALCULATE([Average of Currency.Use], FILTER('RAW Data','RAW Data'[Infare-CarrierNumber.Number] = 1))
VAR DiffOth = [Average of Currency.Use]
RETURN DiffOth - DiffPG

Please advise me.

Regards,

[v-shex-msft]

Hi @hanami001,

If your measure contains specific filter or other conditions, it might not works properly when you nested with other measure or filters.

Optimizing DAX expressions involving multiple measures

Nested Measure Performance

Please share some sample data with measure formulas to help us clarify your table structure and coding formula.

Regards,

Xiaoxin Sheng