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(             FactInter...
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

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