cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

Difference of Rows

working on a project where I want to create measure/DAX of price difference between brands.Using the following data I want to create the price diffrence between Brand A with All other brands for regions.

Sample data:

 Brand Name Region Date Price A X 22-09-2021 300 B X 22-09-2021 320 C X 22-09-2021 310 A Y 22-09-2021 330 B Y 22-09-2021 316 C Y 22-09-2021 321 A Z 22-09-2021 337 B Z 22-09-2021 337 C Z 22-09-2021 310 D Z 22-09-2021 302 E Z 22-09-2021 328 F Z 22-09-2021 335
3 REPLIES 3
Community Support

Hi @BhoomiT

try this

``````difference =
var _PriceA = CALCULATE(MIN('Table'[Price]),FILTER(ALLSELECTED('Table'),'Table'[Brand Name]="A"))
var _currPrice = MIN('Table'[Price])
return _currPrice-_PriceA``````

result

if you need more help, please @ me.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Super User

@BhoomiT , A new column for price of A and then you can take a diff

A price = maxx(filter(Table, [region] =earlier( [region] ) && [Brand Name] ="A") , [Price])

diff = [Price] -[A price]

a measure, if needed

A price = maxx(filter(allselected(Table), [region] =max( [region] ) && [Brand Name] ="A") , [Price])

Frequent Visitor

Thank You Amit,

This is working perfact up to region level filters but, when I tried to calculate it at branch and terittory level ( level down the region) then there is minor deviation in the calculation.

request you to please guide me how can I calculate a measure so that it works for region, branch, terittory filters as well as time filters.

Announcements

Fabric certifications survey

Certification feedback opportunity for the community.

Power BI Monthly Update - April 2024

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

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors