Forum Discussion
Count duplicate values
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
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.
Pawel,
Wow! Thanks! There is a minor difference from what I calculated in Excel, but I will search for that (some of the data in each column is not good - wrong number of digits, etc). So now, two more questions:
1. The Number of Duplicates is 6 digits. How do I get it to put in a comma?
2. The Percent of Duplicates shows as a decimal (0.19). How do I express it as a percent (19%)?
Thanks again, you may have made me a hero!
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
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.
Never mind, I discovered that I need to select the measure so the formula appears, then format works!
Thanks for your help!