Calculation of Total Amount With Sales Entry

[AudreyT]

Where does the total amount pull from if there are no sales entered at all for a specific tenant?

[AudreyT · Accepted solution]

Hello All,

I am still working with our internal team to figure out where these amounts are pulling from, but I believe it has to do with changes on the system where Power BI pulls these totals that is causing the issue.

Thank you all for your input!

[v-anbandari]

Hi @AudreyT    ,

Just checking in to see whether the issue has been resolved. If you still need any assistance, please feel free to reach out and we’ll be happy to help.

Thank you.

[v-anbandari]

Hi @AudreyT ,

Thank you for the update. It does seem that recent changes in the source system may be causing these totals to appear. Please continue validating the source data with your internal team to help identify the root cause.

Feel free to reach out if you need any further assistance.

Thank you.

[v-anbandari]

Hi @AudreyT  ,

Could you please confirm if your query has been resolved by the provided solution? This would be helpful for other members who may encounter similar issues.

Thank you for being part of the Microsoft Fabric Community.

[danextian]

Power BI will not show any data if there isn't any data at all.  Could you please provide more context?

[AudreyT]

Below is a screenshot.  As shown, there is no sales data entered for 2025 or 2024 but there is a total amount and not sure where it is pulling from.

 I believe it has to do with the corresponding system we use that pulls the data.  There may have been some changes there that is pulling these numbers.

@danextian @ryan_mayu 

[v-anbandari]

Hi @AudreyT ,

Thank you for reaching out to the Microsoft Fabric Community.

Your calculation is not ignoring filters, as this can cause values to appear even when no data exists. Also, verify that the relationships between your Date, Tenant, and Sales tables are correctly set and active so that filters flow properly. In addition, you may want to check your visual settings (such as “Show items with no data”), as this can sometimes display values for years without records. Finally, please confirm that the data is not coming from any pre-aggregated or external source.

Please feel free to reach out if you need any further clarification.

Thank you.

[ryan_mayu]

@AudreyT 

I don't think we have that,maybe we can use some ways to create it. could you pls provide some sample data and expected output?

[krishnakanth240]

Hi @AudreyT 

If tenant has no corresponding rows in the Sales table, then measure SUM(Sales[Amount]) does not pull data from anywhere so it evaluates over an empty filter context and returns BLANK. 

You will only see a value if there are actual rows even if the amount is 0 or if the measure explicitly converts blanks to 0 using functions like COALESCE or IF.