If I'm using virtual table in my measure, what function to display it?
So I have measure like this :
Go to Solution.
VAR VirtualTable =
"GroupType", IF ( [Value1] < 10, "Small", "Big" )
ALLSELECTED ( DimDate[Date] )
CONCATENATEX ( VirtualTable, [GroupType], ", " )
Please mark the question solved when done and consider giving kudos if posts are helpful.
View solution in original post
but I had to ask why CONCANTENATE ? It is to combine text right?
My expectation for the display result is actualy only 1 word.
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
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Get an overview of the events and great community content from November.
Find out where you can attend!