Display table with duplicates and Filters / Remove duplicates

[Syndicate_Admin]

good!!
My query is whether there is a way to remove the following duplicate from the visualization.

the empty row is not incorrect, however, when a change is made to the base, of COD2, the information in the previous row is irrelevant and only takes up space in the visualization. I can't take it out by filtering as it would delete the rest, both BRRDR and Fllpr Trl. For example, reloading BRRDR/Fllpr Trl information would empty BRRDR/QP TS.

The modeling is simple:

Basically, the page filters are Advisor and Company. The table is done with Cod from the Data table.

PS: I can't upload the pbix for the data.

[v-rzhou-msft · Accepted solution]

Hi @Syndicate_Admin 

Do you want to remove the empty row instead of takeing up space in the visualization?

In this sample, I think you may want to remove BRROR/Filpr Tril

Table visual will hide empty row by default, please check your COD and COD2 column in Table visual and turn off Show items with no data.

Or you can try to build a filter measure to show result as you want.

Filter Measure is as below. Let's get two list table _COD and _COD2 which are empty.

Then use if function to show 0 when the row is empty and show 1 when the row has value.

Measure = 
VAR _COD = CALCULATETABLE(VALUES('Table'[COD]),FILTER('Table','Table'[C]+'Table'[R]+'Table'[P]+'Table'[E] = BLANK()))
VAR _COD2 = CALCULATETABLE(VALUES('Table'[COD2]),FILTER('Table','Table'[C]+'Table'[R]+'Table'[P]+'Table'[E] = BLANK()))
Return
IF(MAX('Table'[COD]) IN _COD && MAX('Table'[COD2]) IN _COD2,0,1)

Add this measure into Filter Field in Table visual. And set it to show items when the value = 1.

Best Regards,

Rico Zhou

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

[Syndicate_Admin]

Thanks a lot!!

I was very helped by your contribution, I did not know that you could directly exclude a row in that way.

Another query, if I want to re-include it as I do without making the table again from scratch.

Best regards.

[Syndicate_Admin]

I saw it!! Excluded rows appear on the Filters tab