Power BI Measure and DAX Review for Wrong Totals
Find why numbers differ from the source or between visuals.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.
Review these DAX measures and the numbers they produce. Measures and formulas: [DAX_MEASURES]. Where the numbers differ (visual, filter, expected value, shown value): [DISCREPANCIES]. Model description: [MODEL_NOTES]. For each discrepancy, trace the calculation in words: which tables filter which, what filter context applies in that visual, and where the difference arises. Check for totals computed differently from row values, ALL or REMOVEFILTERS removing too much, dependence on inactive relationships, blank handling, and division by zero. Recalculate the example by hand with the arithmetic shown. Be explicit about assumptions; if I did not give enough information, list the extra things to check, such as the filter pane for the visual. Return a table with Cause, Evidence, Fix and Test, mark formula suggestions [VERIFY] and explain how to test each in a table visual. Add a short guide to reading filter context. Put the most likely cause first for each discrepancy and say what single check would confirm it. If more than one measure shares the same problem, group them so one fix can cover several.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.