Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
1 year ago
Solved

Sum per Week and Filter

Hi and good day, Can anyone pls need help on my measure. Measure1 = Sum per Week per Location Measure2 = Sum per Code per Week per Location PLS NOTE: Need to Filter  Type = Indirect DE...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    hi AllanBerces 

     

    Please try these:

    Measure1 =
CALCULATE (
    data[hrs],
    ALLEXCEPT ( data, data[week no], data[location] ),
    KEEPFILTERS ( data[filter type] = "indirect" )
)


Measure1 =
CALCULATE (
    data[hrs],
    ALLEXCEPT ( data, data[week no], data[location], data[code] ),
    KEEPFILTERS ( data[filter type] = "indirect" )
)
danextian's avatar
danextian
Super User
1 year ago

hi AllanBerces 

 

Please try these:

Measure1 =
CALCULATE (
    data[hrs],
    ALLEXCEPT ( data, data[week no], data[location] ),
    KEEPFILTERS ( data[filter type] = "indirect" )
)


Measure1 =
CALCULATE (
    data[hrs],
    ALLEXCEPT ( data, data[week no], data[location], data[code] ),
    KEEPFILTERS ( data[filter type] = "indirect" )
)