Return field value from Virtual table (VAR) in measure

[admin_xlsior]

Hi,

If I'm using virtual table in my measure, what function to display it?

So I have measure like this :

MeasureType =

VAR VirtualTable =

CALCULATETABLE(

ADDCOLUMNS(

            FactInternetSales,

            "GroupType", IF ([Value1] < 10, "Small", "Big")

        ),

        ALLSELECTED( DimDate[Date] )

    )

Return ????

What should I use in "Return" to display VirtualTable[GroupType]

Thanks,

[AlB · Accepted solution]

Hi @admin_xlsior 

MeasureType =
VAR VirtualTable =
    CALCULATETABLE (
        ADDCOLUMNS (
            FactInternetSales,
            "GroupType", IF ( [Value1] < 10, "Small", "Big" )
        ),
        ALLSELECTED ( DimDate[Date] )
    )
RETURN
    CONCATENATEX ( VirtualTable, [GroupType], ", " )

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers  

[admin_xlsior]

Hi thanks,

but I had to ask why CONCANTENATE ? It is to combine text right?

My expectation for the display result is actualy only 1 word.

thanks,

[AlB]

It's just to cover for the possibility that there were more than one and avoid errors. In any case, don't worry, the concatenatex will work just as well with only one word

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers