Error fetching data for this visual - 2 fact tables, 2 totalytd measures, 1 matrix visualisation

[Adam_Zuk]

Hi, here is my error.

I have 2 fact tables, 2 measures counting sum of YTD   - TOTALYTD,  1 matrix visualisation and when I'm going into days I get an error.

When I'm looking into year, quarters, months ist's ok.

Please Help 🙂 to understand.

Adam

[v-pnaroju-msft]

Hi Adam_Zuk,

We are writing to follow up and ask whether the issue has been resolved on your end. If it remains unresolved, please provide sample data that clearly demonstrates the problem or question in a structured (non-image) format so we can better understand and address it. Ensure the data is relevant, does not contain any sensitive information, and directly relates to the issue. Also include the expected outcome based on the provided example.

If you have any further questions, please feel free to contact the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Thankyou, @MFelix, @danextian and @mnadeemsalam for your responses.

Hi Adam_Zuk,

We are writing to follow up and inquire whether the issue has been resolved at your end. If it remains unresolved, as suggested by @MFelix, @danextian and @mnadeemsalam, please provide sample data that clearly demonstrates the problem or query in a structured (non-image) format to help us understand and address the matter. Ensure that the data is relevant, free of any sensitive information, and directly related to the issue. Additionally, please state the expected outcome based on the provided example.

If you have any further queries, please feel free to contact the Microsoft Fabric community.

Thank you.

[mnadeemsalam]

Hi @Adam_Zuk ,

Thanks for sharing the details. To properly identify what’s causing the error in your YTD measures at the day level, I’ll need a bit more information.

1. Could you please share a sample dataset or PBIX?

Please upload:

• A small mock dataset (Excel or CSV) — not screenshots

• Or a sanitized PBIX with just the relevant tables/measures

You can use OneDrive, Google Drive, WeTransfer, etc.
This doesn’t need to contain confidential data — just enough structure to reproduce the issue.

2. Some potential causes based on what you described

From the behavior you mentioned, here are a few likely reasons:

• Missing dates in one of your fact tables
  TOTALYTD relies on a complete Date table and proper relationships.
  If a fact table is missing certain dates, drilling down to the day level may return errors or blanks.

• Date table is not marked as a Date Table
  Ensure your calendar table is:

  • Continuous (no gaps)

  • Has a single-column date key

  • Marked as “Date Table” in Power BI

• Incorrect model relationships
  If both fact tables connect to the Date table using different granularity or inactive relationships, YTD calculations may conflict when drilling to lower levels.

• Use of multiple fact tables in one visual
  Sometimes mixing measures from two separate fact tables inside the same matrix can cause context issues unless your Date table is the single, central relationship.

Once you share a sample file, I’ll help pinpoint the exact cause and show you how to fix it.

Regards,

Nadeem

Did I answer your question? If so, please mark this as a solution to help others in the community.

[Adam_Zuk]

I try to simplyfy my pbi file and send it to You to analyze.

I think I have one clue... one of the fact tables doesn't have all the days in the date column

If I put  measures to simple table visualistion everything works great.

Maybe this is the way ... to resolve it.

Thanks for your involvement.

[danextian]

Hi @Adam_Zuk 

Please provide a workable sample data (not an image), your expected result from the same sample data and your reasoning behind. You may post a link to Excel or a sanitized copy of your PBIX stored in the cloud. A sample data set doesn't need to be confidential, but it should accurately reflect your actual data. While creating one might involve considerable effort, providing solutions can also be time-consuming. Help us help you.

[MFelix · Accepted solution]

Hi @Adam_Zuk ,

Without further information is difficult to pinpoint your error.

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.