Forum Discussion

mya's avatar
mya
Frequent Visitor
2 years ago

Selectedvalue

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 .

Need Help

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    2 years ago

    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's avatar
      mya
      Frequent Visitor
      2 years ago

      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