topic Re: Filter Matrix to have values that show 1 in DAX Commands and Tips

Filter Matrix to have values that show 1

Anonymous — Wed, 02 Nov 2022 12:45:37 GMT

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)

Re: Filter Matrix to have values that show 1

v-xiaosun-msft — Thu, 03 Nov 2022 09:40:44 GMT

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.

Re: Filter Matrix to have values that show 1

Anonymous — Thu, 03 Nov 2022 14:15:19 GMT

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

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.

Re: Filter Matrix to have values that show 1

v-xiaosun-msft — Fri, 11 Nov 2022 05:49:03 GMT

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.