Solved: Need Help please - Page 2

Sirfyaad · 05-15-2023 07:01 PM

I have created two virtual columns. With the help of which I want to count the unique [team name] But my [team name] is of Enumlist types. Whose doing is single counting two names.

First virtual column expression

SPLIT(CONCATENATE([TEAM NAME]), " & ")

Second Virtual Column Expression

COUNT(UNIQUE(FILTER("photos"[First Virtual], IN([DATE], LIST(TODAY())))))

Izzat_Safrah

Good day @Sirfyaad

Try this idea it will work

[First virtual column] expression Type of the column LIST

SPLIT(SELECT(photos[TEAM NAME],AND(CONTAINS([TEAM NAME], "&"),[DATE]=TODAY()) ),"&")
+
SELECT(photos[TEAM NAME], AND(NOT(CONTAINS([TEAM NAME], "&")),[DATE]=TODAY()))

[Second Virtual Column] Expression Type of the column Number

COUNT( UNIQUE([First virtual column]))

View solution in original post