referencing a column in a virtual table in a measure

[Syndicate_Admin]

Good.

I have created a measure in which one of its variables is a virtual table. Subsequently, I want the RETURN to make me the DISTINCTCOUNT calculation of a column of that virtual table contained in the variable, but I cannot refer to that column.

Any ideas?

Thank you.

[Syndicate_Admin]

Right now I have something similar to this:

Measure =

WHERE tablaVirtual =

ADDCOLUMNS(

SUMMARIZE (

board

table[column]

),

"column1", MAX(table[column])

)

return

DISTINCTCOUNT( tablaVirtual[columna1])

This doesn't work for me. When it comes to indicating Virtual Table[column1] within the DISTINCTCOUNT, it does not allow me.

[Jihwan_Kim]

Hi,

I am not sure if I understood your measure correctly, but could you please try something like below?

Measure: =
VAR tablaVirtual =
    ADDCOLUMNS (
        SUMMARIZE ( board, table[column] ),
        "column1", MAX ( table[column] )
    )
RETURN
    COUNTROWS ( SUMMARIZE ( tablaVirtual, [column1] ) )

[Jihwan_Kim]

Hi,

I suggest try to use SUMMARIZE or SELECTCOLUMS function. And then I think you can try to select only the column that you want to look for.

Thanks.