costum column token eof erro

[AlessandroBe]

Column = VAR myrow={[A],[B],[C],[D]}
RETURN
COUNTROWS(Filter(myrow,[Value]="Yes"))

what is wrong? 

[Anonymous · Accepted solution]

Hi @AlessandroBe 

Original data :

Then create a table to return the “YES” and “NO” .

Table 2 =
var _a=SELECTCOLUMNS('Table',"Value",[A])
var _b=SELECTCOLUMNS('Table',"Value",[B])
var _c=SELECTCOLUMNS('Table',"Value",[C])
var _d=SELECTCOLUMNS('Table',"Value",[D])
RETURN UNION(_a,_b,_c,_d)

You will get a result as shown :

Create a measure to count the number of “YES”

Measure = CALCULATE(COUNT('Table 2'[Value]),'Table 2'[Value]="yes")

Put the measure in a card visual .

I have attached my pbix file , you can refer to it .

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@AlessandroBe , What are you trying to achieve here?

If you want to create a table with multiple rows. Then use Row and union

example

union(

ROW("Month", 1),
ROW("Month", 2),
ROW("Month", 3)
)