Data won't load in a table with a DAX measure.

[Anonymous]

Hi guys,

Why my data won't load when I add a measure?

The table below is supposed to show the arrears (decimal number) by financial year (text).
Each field comes from a different table.
 

Arrears £ = CALCULATE(

SUM('Account Balance Weekly'[FAB_CURRENT_ARREARS_BALANCE_TO]),

'Account Balance Weekly'[DTE_CURRENT_FORMER] = "C",

FILTER(Rent_Account,Rent_Account[Account Class] = "REN"))

Below is a table with the financial year and the field that I used to create the measure above.

Thank you!

[PC2790]

I suppose you are using Direct Query as this is a know limitation of Direct Query.

Refer Cosniderations & Limitation section-Use DirectQuery in Power BI Desktop - Power BI | Microsoft Docs

Could be that there are more than 1M records in your dataset.

You cna try to limit the data or you can run the quesry while fetching the data to get rows less than 1 million