Forum Discussion

dpiechowski's avatar
dpiechowski
Helper I
6 years ago
Solved

Calculated Sum filtering

I'm trying to write a measure that will serve as a basis for conditional formatting. I want to highlight the a given JOB # blue if the FG sum exceeds the RUN_QTY, but I need to filter the finished go...
Need Help
  • dpiechowski's avatar
    dpiechowski
    6 years ago

    I got the result I want, but I'm not sure if it's especially efficient or not:

     

    SUMX(FILTER(SPEC_DETAILS,SPEC_DETAILS[MACH_DESCR]=SELECTEDVALUE(PLAN_LINEUP[MACH_DESCR]) && SPEC_DETAILS[PASS_NO] = SELECTEDVALUE(PLAN_LINEUP[PASS_NO])),SPEC_DETAILS[NET_FG_SUM])