Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago
Solved

Display table with duplicates and Filters / Remove duplicates

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

DUPLICADOS.PNG

DUPLICADOS 2.PNG


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:

DUPLICADOR 3 MOD.PNG

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.

  • Anonymous's avatar
    Anonymous
    5 years ago

    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. 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
      Syndicate_Admin
      Administrator
      5 years ago

      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.