Forum Discussion

nhmpp's avatar
nhmpp
Helper I
3 years ago
Solved

Filters not applying

Hello,   I am using this measure:    CALCULATE(Parameter[Parameter Value]*DISTINCTCOUNT(Query1[order_number_id]), FILTER(Query1, Query1[product_type] = "Subscriptions"), FILTER(ALL('Date Table'[...
Need Help
  • nhmpp's avatar
    nhmpp
    3 years ago

    I actually solved this myself after posting using this measure instead:

     

    IF(MAX('Date Table'[Weekday]) IN {"Monday","Tuesday","Wednesday","Thursday","Friday"} && MAX('Time Table'[Time]) >= TIME(9,0,0) && MAX('Time Table'[Time]) <= TIME(15,0,0), CALCULATE(Parameter[Parameter Value]*DISTINCTCOUNT(Query1[order_number_id]), FILTER(Query1, Query1[product_type] = "Subscriptions")) , 0)
nhmpp's avatar
nhmpp
Helper I
3 years ago

I actually solved this myself after posting using this measure instead:

 

IF(MAX('Date Table'[Weekday]) IN {"Monday","Tuesday","Wednesday","Thursday","Friday"} && MAX('Time Table'[Time]) >= TIME(9,0,0) && MAX('Time Table'[Time]) <= TIME(15,0,0), CALCULATE(Parameter[Parameter Value]*DISTINCTCOUNT(Query1[order_number_id]), FILTER(Query1, Query1[product_type] = "Subscriptions")) , 0)