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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
TheLoonies
Frequent Visitor

Data seems to be summarized incorrectly

Hi,

 

I have a dataset created from a PBI datamart.

 

TheLoonies_0-1684216346835.png

On the matrix visual we can see that the totals for week 5 and 6 are 227 and 211 respectivly.

 

on the line chart the counts are listed as 50 and 58.

 

After I apply a filter it looks like this:

 

TheLoonies_1-1684216607585.png

Now the numbers match as expected. the matrix counts reduce as expected, but the numbers on the visuals on the right increase. Any ideas what's causing this behaviour, or how I can fix it?

 

Thanks

2 REPLIES 2
v-xinruzhu-msft
Community Support
Community Support

Hi @TheLoonies 

Can you provide some sample data based on your picture, so that can provide some suggestion for you.

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

No, it doesn't appear to be worth the effort to continue here. I'm going to open a support ticket about the issue instead. Thanks anyway.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors