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 ...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

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

prakchan499's avatar
prakchan499
Advocate I
9 years ago

Hi Lydia, 
Since my data model is in SSAS  Tabular model, I am seeking solution in SSAS, however I tried the same in another dashboard where I am pulling data using Direct Query, there it was not supporting either.

 

However in case of SSAS 2012 SP1 (1103), this function isn't available.

Thanks