Forum Discussion

tborg's avatar
tborg
Helper I
9 years ago
Solved

Count duplicate values

I have a table with 2 columns of numbers.  I want to count the number of times any value anywhere in column 2 also occurs anywhere in column 1.  In other words, if there are 10 numbers in column 2 th...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi tborg,

     

    Thanks.

     

    You can simply use the following pattern to format the measures (or columns):

     

    1. Select the measure on the right in the Fields panel.

    2. Navigate to the Modeling tab in the top ribbon.

    3. Use  Formatting section of the Modeling tab to format the measure the way you want.

     

    Cheers,

    Pawel

  • Anonymous's avatar
    Anonymous
    9 years ago

    And one more thing. I've just realized it's safer to use COUNTROWS function in Percentage of Duplicates measure:

     

    Percent of Duplicates = DIVIDE([Number of Duplicates], COUNTROWS(Table1))

    By doing that you make yourself secure from the situations where null values appear in Column1.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi tborg,

 

Thanks.

 

You can simply use the following pattern to format the measures (or columns):

 

1. Select the measure on the right in the Fields panel.

2. Navigate to the Modeling tab in the top ribbon.

3. Use  Formatting section of the Modeling tab to format the measure the way you want.

 

Cheers,

Pawel

tborg's avatar
tborg
Helper I
9 years ago

Pawel,

I created a separate card for each of the 2 measures.  When I select the measure and go to Modeling, the Format options are greyed out.   I changed the data type from Text to Number, but it made no difference, the format options are still not available.

 

Suggestions?

 

Thanks.

  • tborg's avatar
    tborg
    Helper I
    9 years ago

    Never mind, I discovered that I need to select the measure so the formula appears, then format works!

     

    Thanks for your help!