Forum Discussion
Matrix Table - No Aggregation (Just cross table with text values)
Hi,
In the excel, we have option called no-aggregate in pivot table, where values including text just appears as is. however in Matrix table we need measure with aggregated numeric value,
Refer my below screen, where I have questions as columns, and answers as values (alpha-numeric), now how this can be achieved is my problem without aggregation.
6 Replies
Hi prakchan499
you could have a measure returning text for each column you want to display that way,
e.g.
DisplayAsText = CONCATENATEX( table, table[yourTextColumn], ", ")
does this beahve like you want it to?
HTH,
Frank
Hey Frank,
I tried this function in my PBI (Direct Query) measure as well as in SSAS Tabular (2012/2014) DAX expression, it seems like unavailable in my environment, let me konw if I missed anything.
Thanks for your response.Hi prakchan499,
Do you connect to SQL Server database using "DirectQuery" mode? If so, what is the problem after you create the measure using BetterCallFrank's formula.
Thanks,
Lydia Zhang
Hi Frank,
I've created this measure but I'm not sure how this should then be applied to the matrix? here is the measure
And the matrix prior to adding the measure as value:
It appears to just give me a huge table comma separated when the measure is added as values
I can't seem to get it to separate out along the columns
Any help would be greatly appreciated!
