Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
hanami001
Frequent Visitor

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.

 

Capture001.PNG

 

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

 

Capture002.PNG

 

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 1
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.