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.
Hi all,
I have a measure that works except when I add a date component to my visual. It appears to be evaluating for each period instead of utilising the extenal filter that was applied to the visual. There should be a third column for 2023/24 02 which designates a failure in that period for asset 34332 but as it was only one failure in that period it has been omitted - the evaluating date parameter should be less <= 84 days.
Sample data:
ASSET_NUM | ASSET_DESC | TICKET_ID | RAISED_DATE | RAISED_YEAR_PERIOD |
34332 | West | 2985693 | 03/04/2023 | 23/24-P01 |
34332 | West | 2986260 | 18/04/2023 | 23/24-P01 |
34332 | West | 2986718 | 24/04/2023 | 23/24-P01 |
34332 | West | 2986745 | 27/04/2023 | 23/24-P01 |
34332 | West | 2986752 | 30/04/2023 | 23/24-P02 |
34332 | West | 2987520 | 31/05/2023 | 23/24-P03 |
34332 | West | 2987772 | 12/06/2023 | 23/24-P03 |
34332 | West | 2987747 | 12/06/2023 | 23/24-P03 |
34332 | West | 2988094 | 21/06/2023 | 23/24-P03 |
I am trying to build in a date component into the measure to see if it fixes the issue.
My original measure:
Repeat Failures = COUNTROWS(
FILTER(
SUMMARIZE(
'CS_RPT_Failures','CS_RPT_Failures'[ASSETNUM],
"TICKETID",
COUNT('CS_RPT_Failures'[TICKETID])
),
[TICKETID]>= 3 && ISBLANK([TICKETID]) = FALSE)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
70 | |
36 | |
21 | |
18 | |
15 |
User | Count |
---|---|
126 | |
30 | |
28 | |
24 | |
22 |