cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Michieldo
Helper III
Helper III

Comparing prices same table based on filter

Hello,

 

I have one table containing prices of several webshops for different products within different product categories. I would like to present the price difference between a selected webshop and the other webshops.

DateWebshopCategoryProductPrice
01/01/2021ACat AProduct A10
01/02/2021ACat AProduct A10
01/01/2021ACat BProduct B15
01/01/2021BCat AProduct A9
01/01/2021BCat BProduct A9
01/01/2021BCat BProduct B12
01/01/2021CCat ACat6

 

My preferred output table looks like:

DateProductCatWebshop AWebshop BWebshop C
01/01/2021AA014
01/01/2021BA03-

 

And changes depending on the filter on the webshop. Any suggestions how to solve this in DAX?

 

Thanks a lot for your help !

 

Michiel

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Michieldo , With an independent table for Webshop slicer

try a measure like

 

sum(Table[Price]) - sumx(filter(allselected(Table[Webshop]), Table[Webshop] = Selectedvalue(Webshop[Webshop])),[Price])



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

3 REPLIES 3
yingyinr
Community Support
Community Support

Hi @Michieldo ,

Could you please provide the related caculation logic of your preferred output? Why Webshop A is 0 , Webshop B is  1 and 3 for Product A and B separately and Webshop C is 4 for Product A base on your sample data?

Date Product Cat Webshop A Webshop B Webshop C
01/01/2021 A A 0 1 4
01/01/2021 B A 0 3 -

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super User

@Michieldo , With an independent table for Webshop slicer

try a measure like

 

sum(Table[Price]) - sumx(filter(allselected(Table[Webshop]), Table[Webshop] = Selectedvalue(Webshop[Webshop])),[Price])



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Thanks, almost perfect! Allselected didn't work for me, but using Allexcept() in combination with the columns on which I did want to keep the filters on worked.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!