Selectedvalue

[mya]

Hi 

Need a help . I have a usecase where  user selects a category in a slicer(There are 17 categories in the dropdown list and the slicer is a single selection ). There is a matrix which will show list of customers bought that category and purchase amount. 

Now in the same matrix i want to show the what is the purchase amount for the same set of customers for other categories (16 categories). I tried using unable edit interaction but didn't work . 

Please help .

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

One of ways is to create a disconnected slicer table like below.

Please check the below picture and the attached pbix file.

Sales selected category: = 
CALCULATE (
    SUM ( Sales[Sales] ),
    Category[Category] IN VALUES ( 'Category slicer'[Category] )
)

Sales other category: = 
CALCULATE (
    SUM ( Sales[Sales] ),
    NOT ( Category[Category] IN VALUES ( 'Category slicer'[Category] ) )
)

[mya]

Hi Thank you for the solution, 

1.But the customer listed in the matrix should be list of those customers who bought category 11 

2. then i wan to see the purchase amount for the same customers for unselected categories also in the same matrix 

3. All the unselected categories should be in the column name