Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, thanks for your time.
i add a measure as below to draw a issue trend chart.
the problem is this measure will only count which the cell which had filled in issue close finish date. it will not count test finish date with blank cell.
how should I solve it ? I have to count the issue still not yet close as well. Many thanks!
(PS: assume issue close date as "today" is not what I want, due to it will have some issue due to make visual)
Solved! Go to Solution.
hi all, thanks for your feedback. in the end, I test yours but not suitable what I need.
I attached final code, which is stupid but workable for me 🙂
hi all, thanks for your feedback. in the end, I test yours but not suitable what I need.
I attached final code, which is stupid but workable for me 🙂
Hi @Venson ,
Please try the formula:
DIR2.0 Count SUM =
VAR Project = 'Dim_Project_List'
VAR DIRlinechart =
CALCULATE
(
SUM('Issue_ODM'[Custom]),
FILTER
(
'Issue_ODM',
'Issue_ODM'[Issue Open date]<=MAX('Calendar'[Date]) &&
( 'Issue_ODM'[Issue close date]>=MAX('Calendar'[Date]) || 'Issue_ODM'[Issue close date] = BLANK() )
)
)
RETURN
DIRlinechart+0
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Venson , This is very similar to my HR Blog. Refer blog and files attached
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |