Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
Hi @JKHATRAK ,
Please update the formula of the measure [Last Engagement Made Greater than 15 days] as below and check if it works or not...
Last Engagement Made Greater than 15 days =
CALCULATE (
SUM ( 'Raw Data'[USD] ),
FILTER (
'Raw Data',
'Raw Data'[Days since last engagement] = "Greater than 15days"
&& 'Raw Data'[Excuse Code Description]
IN {
"Business Interruption",
"Contact Made",
"Credit Balance Known to customer",
"0.Default",
"9.Govmt/Institution Slow Pay/Funding",
"7.Payment Awaiting Approval",
"11.Pending Support from Business",
"4.Customer Researching",
"5.Credit Balance,In Research",
"6.Unresponsive Customer",
"1.Initial Contact pre due date"
}
&& 'Raw Data'[Pocket] IN { "1-30", "31-60", "61-90", "91-120", "Over 120" }
)
)
And you can use DAX Formatter to format your formula and check there is no syntax error...
If the above one can't help you get the desired result, please provide some sample data in your table 'Raw data' (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
Hi @JKHATRAK ,
Please update the formula of the measure [Last Engagement Made Greater than 15 days] as below and check if it works or not...
Last Engagement Made Greater than 15 days =
CALCULATE (
SUM ( 'Raw Data'[USD] ),
FILTER (
'Raw Data',
'Raw Data'[Days since last engagement] = "Greater than 15days"
&& 'Raw Data'[Excuse Code Description]
IN {
"Business Interruption",
"Contact Made",
"Credit Balance Known to customer",
"0.Default",
"9.Govmt/Institution Slow Pay/Funding",
"7.Payment Awaiting Approval",
"11.Pending Support from Business",
"4.Customer Researching",
"5.Credit Balance,In Research",
"6.Unresponsive Customer",
"1.Initial Contact pre due date"
}
&& 'Raw Data'[Pocket] IN { "1-30", "31-60", "61-90", "91-120", "Over 120" }
)
)
And you can use DAX Formatter to format your formula and check there is no syntax error...
If the above one can't help you get the desired result, please provide some sample data in your table 'Raw data' (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
Thank you Very Much. This works 🙂
@JKHATRAK Hard to tell exactly but that is definitely incorrect syntax. Try one of these:
Last Engagement Made Greater than 15 days =
CALCULATE(
SUM('Raw Data'[USD]),
'Raw Data'[Days since last engagement] = "Greater than 15days",
'Raw Data'[Excuse Code Description] IN { "Business Interruption","Contact Made","Credit Balance Known to customer","0.Default","9.Govmt/Institution Slow Pay/Funding","7.Payment Awaiting Approval","11.Pending Support from Business","4.Customer Researching","5.Credit Balance,In Research","6.Unresponsive Customer","1.Initial Contact pre due date" },
'Raw Data'[Pocket] = "1-30","31-60","61-90","91-120","Over 120"
)
Last Engagement Made Greater than 15 days =
VAR __Table =
FILTER('Raw Data',
'Raw Data'[Days since last engagement] = "Greater than 15days",
'Raw Data'[Excuse Code Description] IN { "Business Interruption","Contact Made","Credit Balance Known to customer","0.Default","9.Govmt/Institution Slow Pay/Funding","7.Payment Awaiting Approval","11.Pending Support from Business","4.Customer Researching","5.Credit Balance,In Research","6.Unresponsive Customer","1.Initial Contact pre due date" },
'Raw Data'[Pocket] = "1-30","31-60","61-90","91-120","Over 120"
)
RETURN
SUMX(__Table, [USD])
User | Count |
---|---|
51 | |
37 | |
20 | |
14 | |
13 |
User | Count |
---|---|
96 | |
71 | |
29 | |
20 | |
13 |