Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Try it like this.
Debit Closing =
SUMX (
VALUES ( Table[ACCOUNTID] ),
IF ( BSBankTrans[Balance] > 0, BSBankTrans[Balance], 0 )
)
You will need to change the name of the table to match whatever is in your model. It is the table that has the [AccountID] field.
Try it like this.
Debit Closing =
SUMX (
VALUES ( Table[ACCOUNTID] ),
IF ( BSBankTrans[Balance] > 0, BSBankTrans[Balance], 0 )
)
You will need to change the name of the table to match whatever is in your model. It is the table that has the [AccountID] field.
User | Count |
---|---|
88 | |
88 | |
75 | |
67 | |
58 |
User | Count |
---|---|
136 | |
110 | |
91 | |
84 | |
69 |