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.
Hello AliceTran1643,
Please look at this similar issues:
Solved: stop aggregation on visualisations - Microsoft Fabric Community
Solved: Stop Power BI aggregating - Microsoft Fabric Community
If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.
Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.
Hello Zanqueta,
Thank you for the links to the 2 posts. I did tried the suggested solutions but the results is not what I'm looking for.