Forum Discussion
Stop Data Aggregation on a Matrix
MasonMA Funny enough. As I am making a sample file to upload, that sample file was able to show the raw data that I wanted. I am guessing since I use the exact same "Particle Type" field in another query instead of the raw data query, it confuses Power BI somehow. Once I use the "Particle Type" field of the raw data query, its working.
Hi,
Are the '# of Units Found A and B' the Power BI implicit measure you used from your table - '# of Units Found' for your Matrix visual (by that i meant you dragged the columns directly onto your Matrix visual)? or that you created DAX measure for report?
If it is the DAX Measure you are using, please share it so that others can take a look.
Hi MasonMA,
This field is dragged into the visual and not a DAX measure. Also, I do not have the option to choose "don't summarize."
This shouldn't be an odd issue from my instinct, but could you share .pbix or the sample file with only the related data and Matrix so that other users can have a look?
MasonMA Funny enough. As I am making a sample file to upload, that sample file was able to show the raw data that I wanted. I am guessing since I use the exact same "Particle Type" field in another query instead of the raw data query, it confuses Power BI somehow. Once I use the "Particle Type" field of the raw data query, its working.
AliceTran1643 ,
You won't get the option of "Don't summarize" in matrix visual's value section. Pull that field into Rows section and then select Don't summarize. Refer to reply 8 of this thread.
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!
Proud To Be a Super User !!!
LinkedIn
