Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
If I'm using virtual table in my measure, what function to display it?
So I have measure like this :
MeasureType =
Solved! Go to Solution.
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
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
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,
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |