Showing all products in a Matrix and populating column values for only products selected in slicer?

[PBIUWO]

Hi,

Can you show all values in a Matrix table (Product Code, Sales History by Month) and only the products chosen in the slicer filter populate a value for Count Quantity? 

Usually, when you click the slicer filter, it filters to remove to show only the product that is in the slicer.

What I want is to keep all the data, but the slicer just chooses the product to populate in the specific column. 

*Count Quantity is a value in a datasource (no calculation) 

Here is what I want: 

Slicer Filter: I choose Product 123-A

So it populates Count Quantity, for only 123-A in all the other ones are blank

Product Code	January 2021	February 2021	March 2021	Count Quantity
123-A	2	3	5	3
123-B	2	2	3
456-A	1	1	2
456-B	2	2	3

[v-kkf-msft]

Hi @PBIUWO ,

You need to copy the Product Code column into a separate table. Use the Product Code in Slicer table as the slicer value.

Create a measure according to the following formula.

Measure Count Quantity = 
CALCULATE(
    SUM('Table'[Count Quantity]),
    FILTER(
        'Table',
        'Table'[Product Code] in ALLSELECTED(Slicer[Product Code])
    )
)

Then select the Product Code field and enable the option "show item with no data" .

This is my PBIX file.

https://microsoftapc-my.sharepoint.com/:u:/g/personal/v-lazhang_microsoft_com/EQYlknZXHepGociuZ-kVrj...

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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

[amitchandak · Accepted solution]

@PBIUWO , Enable this option "show item with no data" 

or  You can show them 0 .

Create a measure with +0

example 

countrows(Table) +0