Comparing all sub-category sales to the selected sub-category

[xariet]

I wonder if it's possible to do in power bi. I need to make a bar chart which will show the difference between the selected sub-category and all other categories. 

SUM Sales for Selected Value = CALCULATE(SUM(Orders[Sales]), ALLSELECTED(Orders[Sub-Category]))

Difference from selected Category = SUM(Orders[Sales])-[SUM Sales for Selected Value] doesn't work. It just shows the selected sub-category and the 0 difference. How do I get to show all other sub-categories and their difference values as well?

[amitchandak · Accepted solution]

@xariet , FOr this better you create a slicer on an independent Sub Category Table

M1= CALCULATE(SUM(Orders[Sales]),Filter( Orders,  Orders[Sub-Category] in values(Orders[Sub-Category])) )

Diff = SUM(Orders[Sales])  - [M1]

Need of an Independent Table in Power BI - Exclude: https://youtu.be/lOEW-YUrAbE

[xariet]

thank you @amitchandak  for your help. your video helped me to understand the solution. I have created a new Orders table and brought sub-category slicer from the new orders table. And then my difference was just the difference in Sales from the ols and new tables. I didn't have to use M1  measure.

Diff = SUM(Orders[Sales])  - [Sum Sales New Table]