Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Conditional Formatting Duplicate Rows in Table that Adjusts with Filters

Hi, I have looked at ways of implementing Conditional Formatting of duplicate table entries, where a calculated column in used to count the number of duplicates for each row and then conditional form...
Need Help
Gabriel_Walkman's avatar
Gabriel_Walkman
Continued Contributor
4 years ago

What was your implementation?

 

The example with the name should work if you use a measure in the conditional settings, ie: distinctcount( [name]), and adjust so that hilighting occurs when it is bigger than 1, smaller than 100000

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I have implemented a calculated column as provided as a solution in this thread:

https://community.powerbi.com/t5/Desktop/Conditional-Formatting-Duplicate-Records-in-Rows/m-p/690739

 

NameDistinctCount = 
VAR NameDistinctCount = Table[Name]
RETURN

CALCULATE(
    COUNTROWS('Table'),
    ALL('Table'),
   Table[Name] = NameDistinctCount
)

 

How do I implement this as a measure?

If I used the same code within a measure, I get an error as follows: "A single value for column 'Name# in the table 'Table' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min,max, count, or sum to get a single result."

 

Seems like an easy fix, I just need to know what it is!