Forum Discussion

Chris203's avatar
Chris203
New Member
3 years ago

Counting unique values in a multi value cell

Hi there,   I built a small status report using MS List and am by no means a programmer or math-wiz. This is just to help our small team better report on work done. I need urgent assistance with t...
Need Help
Washivale's avatar
Washivale
Resolver V
3 years ago

Hey Chris203 ,
you might need a list of unique items that goes to the concatenated column to get what you are looking for

probably something like below
List Items
A
B

C
D

then you will write a measure 

Counts = var __list_item = MAX(List_Items[Values])
return
CALCULATE(COUNT('Table'[Selected Items]), CONTAINSSTRING('Table'[Selected Items],__list_item))

then you will use List_Items[Values] and newly created measure on your clustered chart


 


thanks,
Sandeep