Forum Discussion

purplehaze's avatar
purplehaze
Advocate I
8 years ago

Remove summarization of Matrix Values

Hello,   I'm trying to create a Matrix table that maps a user's answer score to a question for multiple users. In my database I have the questions, user identifiers and their answer scores for the ...
Need Help
Show and Tell
Tips and Tricks
purplehaze's avatar
purplehaze
Advocate I
8 years ago

Hi edejes2

 

Thanks for your reply, I added the images to my public album and added them - can see them this end so probably user error somewhere...

 

Data is being imported rather than DirectQuery if that's what you're referring to?

 

The behaviour I'm seeing is with the data type set to whole number for data type and format. I've got the category set to Uncategorized and I've set the Default Summarization to 'Don't summarize'. With these settings, there's no don't summarize option. I've had a play with other datatypes etc and all seem to enforce summarization on the Matrix table values field.

 

Thanks,

PH

edejes2's avatar
edejes2
Advocate IV
8 years ago

Hi purplehaze

 

I not sure if you already did this on you PBIX for those specific fields.

 

 

Regards!

ED

  • purplehaze's avatar
    purplehaze
    Advocate I
    8 years ago

    Hi edejes2

     

    Thanks for the reply, yes had tried your suggestion on the data fields. The issue is the Matrix visual seems to enforce some sort of summarization still.

     

    Luckily, I found a solution which was to select 'Average' for the values. As there was only 1 value per question per user, it shows the correct value. I can see this being a potential issue in other cases though, maybe from a performance perspective if there's unnecesscary data processing happening? Would be good to see a don't summarize option enabled.