Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
The subject is essentially what I am after and I feel like I am 90% of the way there but when I click on a Calender Month/Year it changes my desired results.
Redesign Customer =
CALCULATE(
MIN('SLA: Design'[Design Queued]),
ALLEXCEPT ( 'SLA: Design', 'SLA: Design'[RID]),
'SLA: Design'[Type] = "Redesign: Customer"
)
MEDIANX(
SUMMARIZE('SLA: Design', 'SLA: Design'[Design Approved],
"Date Difference",
AVERAGEX('SLA: Design',
DATEDIFF([Redesign Customer], 'SLA: Design'[Design Approved], DAY))
),
[Date Difference]
),
However, if I click on a Month/Year filter it changes the results to the first queued date from the 8001 record and I want it to ignore all filters and retain the 6/13/2022 date as I need the 'Total Duration' = 29.
Additionally, I'd love to not include the null value in the Total Duration as it should be 29 and not 14.50. Let me know if I need to provide anymore measures for context.
Thanks!
EDIT: Adding 'Total Duration' measure
Solved! Go to Solution.
I've tried adding ALL into the redesign variable but still changes the date unfortuantely. And I got the Total Duration figured out, instead of summarizing over [Design Approved] I did it over the Primary Key which is RID and that resolved that issue.
Hi @ajbogle ,
You can add another argument to your existing formula. That should be something like:
Redesign Customer =
CALCULATE (
MIN ( 'SLA: Design'[Design Queued] ),
ALLEXCEPT ( 'SLA: Design', 'SLA: Design'[RID] ),
ALL ( 'SLA: Design'[Record ID #] ),
'SLA: Design'[Type] = "Redesign: Customer"
)
For the duration, how do you calculate it? It appers it is being averaged (29/2 = 14.5)
Proud to be a Super User!
I've tried adding ALL into the redesign variable but still changes the date unfortuantely. And I got the Total Duration figured out, instead of summarizing over [Design Approved] I did it over the Primary Key which is RID and that resolved that issue.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |