Matching a card with a measure in to a column in a matrix

[Matt22365]

Hi All

Hope someone can help

I have a matrix table which has product names on rows and ingredients in columns.

The purpose of this is to show which products have which ingredients

Above each column of the table I have a card with a measure in to sum how many products contain the ingredient (from the column its above) and the ingredient in column 1. This works great when the user doesnt use the slicers on the page. However when the Ingredient slicers are used, the columns in the table are moved around accordingly, making it so the cards no longer represent the columns in the matrix

Is there a way to link a measure to which columns / Ingredients are selected so the report becomes more dynamic?

Thanks for your help

Matt 

[Shaurya]

Hi @Matt22365,

It would be great to get some sample data.

Thanks

[Matt22365]

Hi @Shaurya 

Picture below shows the report how I have it.

The numbers above the table are cards with measures to determine the total number of flavours which have Ingredient 1 and one of the other ingredients

What I would like to do next is change the cards so that if the user deselected ingredients 4 and 5 in the slicer and added ingredients 6 & 7, the cards would update to reflect the new columns

Current measures:

Ingredients 1 & 2 =

VAR mat1 =

CALCULATETABLE ( VALUES ( 'Table1'[Flavour] ), 'Table1'[Ingredient] = "Ingredient 1" )

VAR mat2 =

CALCULATETABLE ( VALUES ( 'Table1'[Flavour] ), 'Table1'[Ingredient] = "Ingredient 2" )

RETURN

COUNTROWS ( INTERSECT ( mat1, mat2 ) )+0

Data is simple

Product	Flavour	Ingredients
Product 1	Flavour 1	Ingredient 1
Product 1	Flavour 1	Ingredient 2
Product 2	Flavour 1	Ingredient 1
Product 2	Flavour 1	Ingredient 3

Thanks for your help

Matt