Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
yolanda_meng
Frequent Visitor

Matrix summarization issue sourcing SSAS

Hi all,

 

We are building a Power BI dashboard which Connect Live to a SSAS data source. The issue we are facing now is with the Matrix visual. Whenever we trying to add a column (data type Text in SSAS) into the Values field, it only gives options of 'Count (Distinct)' and 'Count' as summarization type. However, the way we want the data to be displayed is text, so either 'First' or 'Last'. These options are actually exist in Power BI sourcing Database, so not sure if we can change something in the SSAS model to make it work.

 

The first screenshot is what it has in SSAS, and the second is what available in Database model.

 

Capture.PNGMicrosoftTeams-image (7).png

 

Thanks in advance for ideas.

 

3 REPLIES 3
C_Niu
Regular Visitor

@yolanda_meng I have same issue with you. Don't summarize in matix only work when connecting to SQL Server datasource but not SSAS. Hope someone can help.

yao
New Member

We have the same question. Anyone can help ?

lcd327280
Regular Visitor

Got same issue, any advice will be appreciated.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.