Forum Discussion
How to calculated difference value from fixed value
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,
1 Reply
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
Please share some sample data with measure formulas to help us clarify your table structure and coding formula.
Regards,
Xiaoxin Sheng
