Forum Discussion

admin_xlsior's avatar
admin_xlsior
Icon for Post Prodigy rankPost Prodigy
7 years ago
Solved

Return field value from Virtual table (VAR) in measure

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,
 

 

Need Help
  • AlB's avatar
    AlB
    7 years ago

    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  Datanaut

3 Replies

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    7 years ago

    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  Datanaut

    • admin_xlsior's avatar
      admin_xlsior
      Icon for Post Prodigy rankPost Prodigy
      7 years ago

      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's avatar
        AlB
        Icon for Community Champion rankCommunity Champion
        7 years ago

        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  Datanaut