Forum Discussion

prakchan499's avatar
prakchan499
Advocate I
9 years ago

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 ...
BetterCallFrank's avatar
BetterCallFrank
Resolver IV
9 years ago

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

tdmkps's avatar
tdmkps
Frequent Visitor
8 years ago

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

 

measure

 

And the matrix prior to adding the measure as value:

prior

 

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!