Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
With the help of members in this post I have a measure [BankOD RT] which calculates a running total overdue balance. I need to aggregate this across all open accounts (c 1,800 accounts open out of 15,000) and all transactions (c 3,000,000).
The filters I would like are:
// Only Open Accounts DimAccounts[status] = 1 or DimAccounts.[ClosingDate] > [maxDate] // No Deposit Accounts DimAccounts[ProductType] <> "D" // Overdue balance for this account > $200 [BankOD RT] > $200
The result will be a page with:
Since it is only creating one aggregated output figure, does this use CALCULATETABLE? How can I filter the SUMX
HI @pistachio ,
Please share some sample data with expect result to help us clarify your requirement and test to coding formula.
Regards,
Xiaoxin Sheng
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |