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 l...
Need Help
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