Forum Discussion

purplehaze's avatar
purplehaze
Icon for Advocate I rankAdvocate 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
edejes2's avatar
edejes2
Icon for Advocate IV rankAdvocate 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
Icon for Advocate I rankAdvocate 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.