Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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,
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
User | Count |
---|---|
59 | |
58 | |
56 | |
38 | |
29 |
User | Count |
---|---|
82 | |
62 | |
45 | |
40 | |
39 |