Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm trying to create a table where the line in my current formula ....
"Max Value", CALCULATE(MAX(CIAssignees[HadIssues]),FILTER(CIAssignees,CIAssignees[month]=EARLIER(CIAssignees[month]))))
is greater than two. Is there a way to do that?
Solved! Go to Solution.
Hi @PPalkowski .
Try this
New Table =
SUMMARIZE (
'CIAssignees',
'CIAssignees'[FN_Assigned TO],
'CIAssignees'[MonthNo],
'CIAssignees'[Month],
'CIAssignees'[HadIssues],
"Max Value", CALCULATE (
MAX ( CIAssignees[HadIssues] ),
FILTER (
CIAssignees,
CIAssignees[month]
= MAX ( CIAssignees[month] )
&& CIAssignees[HadIssues] > 0
)
)
Regards,
Harsh Nathani
Hi @PPalkowski .
Try this
New Table =
SUMMARIZE (
'CIAssignees',
'CIAssignees'[FN_Assigned TO],
'CIAssignees'[MonthNo],
'CIAssignees'[Month],
'CIAssignees'[HadIssues],
"Max Value", CALCULATE (
MAX ( CIAssignees[HadIssues] ),
FILTER (
CIAssignees,
CIAssignees[month]
= MAX ( CIAssignees[month] )
&& CIAssignees[HadIssues] > 0
)
)
Regards,
Harsh Nathani
yes, you need to add another filter of all the HadIssues > 2. And you will want to think how to handle the situation where this filter comes back empty.
Lets start with what I am looking for,
Each FN_Assigned TO submits several items per month, as little as one as much as 100.
Those , submissions must meet requirements, if ANY submissions for that month had an issue, it would be indicated in the HadIssue column.
What I am trying to do is create a table of ONLY FN_Assigned TOs that had at least one issue in each of the three months, Mar through May,
So from this sample source
FN Assigned To | Mon | HadIssues |
Bruce | Mar | 15 |
Bruce | Apr | 3 |
Bruce | May | 1 |
Clark | Mar | 42 |
Clark | Apr | 0 |
Clark | May | 126 |
Hal | Mar | 1 |
Hal | Apr | 1 |
Hal | May | 1 |
My preferred created table would be
FN Assigned To | Results |
Bruce | 3 |
Hal | 3 |
User | Count |
---|---|
47 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |