Forum Discussion

rodrigof's avatar
rodrigof
New Member
8 years ago

Summarize text columns with conditional formatting

Hi    So I have a text column that will have the following values one of the following values(green, red, yellow) per row.  I'd like to see if I can summarize that data as follows.    Algorithmic...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi rodrigof

For your requirements 1,2, I can get the results as expected.

Create a calculated column

count = CALCULATE(COUNT(Table1[color]),ALLEXCEPT(Table1,Table1[color]))

Measures

max = CALCULATE( MAX([count]),ALL(Table1))

final text = CALCULATE(MAX([color]),FILTER(ALL(Table1),[count]=[max]))

Then edit conditional formatting

 

 

Best Regards

Maggie