Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Column matrix filter

Hello: I have the following matrix: I have the numerical values in the columns of an excel sheet as follows: What I am looking for is to be able to filter that the matri...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Syndicate_Admin ,

 

According to your description, here are my steps you can follow as a solution.

(1) This is my test data.  

(2) We can create a new table.

 

SlicerTable = {"VALOR","Coffee","Confectionery","Dairy-Culinarios"}

 

(3)Then we can create a measure. 

 

Selected Measure = 
VAR __selected = SELECTEDVALUE ( SlicerTable[Slicer] )
RETURN
SWITCH ( __selected,
  "Coffee", SUM ( 'Table'[Coffee] ),
  "Confectionery", SUM ( 'Table'[Confectionery] ),
  "Dairy-Culinarios", SUM ( 'Table'[Dairy-Culinarios] ),
  "VALOR",SUM('Table'[VALOR])
)

 

(4) Then the result is as follows.

Or you can create a field parameter instead of creating a new table and then create a measure, please refer to my pbix.

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.