Filter Matrix to have values that show 1

[Anonymous]

Basically I have this matrix and I want it to only return values in the 'Count of 20 Customer Team Name' and I need these values to be 1... does anyone have a solution to filter it? I tried the filter panel, but because each FPC can go to a specific place once, it didn't help. 

Another solution could be if I turned this to a table... but what would happen is the FPC would show 1 every time, but you would have duplicate FPCs (e.g. FPC 003 would have like 6 entries if it's currently 6 in this matrix) 

[v-xiaosun-msft]

Hi @Anonymous ,

According to your description, I made a sample and here is my solution.

I wonder if you want to only show the value of 'Count of 20 Customer Team Name' which is 1.

You can create a column by using IF function as below.

Column = 
IF('Tabelle1'[count]=1,'Tabelle1'[count])

Or you can use a slicer to select "1".

If the result above is not what you need, please describe your request more clearly and had better provide us a expected output to help you better.

I attach my sample below for your reference.

Best Regards,
Community Support Team _ xiaosun

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

[Anonymous]

How about this, this is a table. 


I want the Corp FPC values to only appear in this able if they are not duplicated. 


E.g. I might have a FPC "920332" and it may say 1 for 5 different people... I don't want this value in this table 

Like:

920332 name

920332 name

etc... 

If it's duplicated, I don't want it

But if i have FPC "932101" and it says 1 only ONE TIME, then I want that value in this table 

I only want the FPC to show up if it's showcasing once in this entire table. 

[v-xiaosun-msft · Accepted solution]

Hi @Anonymous ,

Thanks for your message, check whether the result below is what you need.

Data sample:

Create a calculated column.

Column =
IF (
    CALCULATE (
        COUNT ( 'Table'[count] ),
        FILTER ( 'Table', 'Table'[fpc] = EARLIER ( 'Table'[fpc] ) )
    ) > 1,
    BLANK (),
    1
)

Final output:

I attach my sample below for your reference.

Best Regards,
Community Support Team _ xiaosun

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