Need Help please

[Sirfyaad]

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())))))

 

[Sirfyaad]

Need Help please

@Marc_Dillon 

@Suvrutt_Gurjar 

@WillowMobileSys 

@dbaum 

[Izzat_Safrah]

I think the error is in the way the Expression is written of FILTER()

Examples of how to use:

• FILTER(table-name, filter-expression)
• FILTER("Orders", ([Customer] = [_THISROW].[Customer]))
• FILTER("Products", ([Price] < 100))

[Sirfyaad]

Can you complete this expression and give it? 

[Izzat_Safrah]

Try this expression:

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

[Sirfyaad]

As you can see in the image below. Result 02 is being shown. While team name is unique text 03. 

 

[Sirfyaad]

Please help

[Izzat_Safrah]

---

@Sirfyaad wrote:

First virtual column expression

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

---

The Correct expression

SPLIT([TEAM NAME],"&")

[Sirfyaad]

You tell me how can I correct this expression. 

[Izzat_Safrah]

This is the correct expression. For first virtual column.

SPLIT([TEAM NAME],"&")

[Sirfyaad]

Not working

[Izzat_Safrah · Accepted solution]

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]))

[Sirfyaad]

Hi @Izzat_Safrah 

How can I use this expression in template. Without any virtual column. 

[Izzat_Safrah]

By Create Bot. Event Type ( Scheduled or Data Change ) for run an action.

[Sirfyaad]

I have created bots. The template is also being generated. Just want to put this expression in the template. Without virtual columns.