Forum Discussion

Excellove15's avatar
Excellove15
Iron Contributor
May 30, 2025

Better model to improve the performance calculated table/Dax measures

Hi Team, Now, I have an issue with Data model I have developed. Attached is the model i use for my power bi reports that contains 3 dashboards. Invoice quality is one of the dashboards. Below a...
admin
BI & Data Analysis
office 365
power bi
training
Kidd_Ip's avatar
Kidd_Ip
MVP
May 31, 2025

Would suggest look into:

 

  1. Prevent large datasets calculation
  2. Refactor status calculation using measures:
Status Measure =
SWITCH(
    TRUE(),
    [Number of Invoices] > 1 && [Number of Invoices] > [Number of Credits], "Multiple Invoices",
    [Number of Credits] > [Number of Invoices] && [Net Cost] <> 0, "Multiple Credits",
    ISEVEN([Net Invoices]) && [Net Cost] <> 0, "Invoice-Credit Value Mismatch",
    [Number of Credits] = [Number of Invoices] && [Net Cost] = 0, "Credit Cancels Invoice",
    BLANK()
)

3. Consider aggregating data in Power Query before hits your DAX model

4. Ensure relationship between Invoice Issues, Point and Calendar to minimize slow filtering

5. Leverage summarized tables instead of Row-Based calculations

Resources