Forum Discussion
Solved
Count Weeks Above Target
I have the following tables: - Calendar table (Date, ISO Year, ISO Week Number) - Operation Data (Date, Production Area, Order Number, Labour to be Completed) - Measure (Sum of Labour to be Comple...
LeppyR64 , try like
Count of Weeks Above Capacity =
var tbl = filter(summarize(Fact, DateDimension[Iso Year Week], "util", [Utilization Pct]), [util] > 1)
return COUNTROWS(tbl)
LeppyR64 , try like
Count of Weeks Above Capacity =
var tbl = filter(summarize(Fact, DateDimension[Iso Year Week], "util", [Utilization Pct]), [util] > 1)
return COUNTROWS(tbl)
That worked great. I thought I had tried that, but I must not have done it correctly. Thanks!