Forum Discussion

JustinDoh1's avatar
JustinDoh1
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

How to apply filter here

I have this measure (that I am trying to add more filter):   Skill Mix % Total = Divide(     sum(Table[Average1])     ,       sum(Table[Ave Census]) )   I am trying to add another filter ...
Help with DAX Measure
  • AlexisOlson's avatar
    AlexisOlson
    3 years ago

    Did you forget to include CALCULATE?

     

    Skill Mix % Total 850 =
DIVIDE (
    CALCULATE (
        SUM ( Table[Average1] ),
        FILTER ( Table, Table[FacilityCode] = 850 )
    ),
    CALCULATE (
        SUM ( Table[Ave Census] ),
        FILTER ( Table, Table[FacilityCode] = 850 )
    )
)

     

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
3 years ago

Did you forget to include CALCULATE?

 

Skill Mix % Total 850 =
DIVIDE (
    CALCULATE (
        SUM ( Table[Average1] ),
        FILTER ( Table, Table[FacilityCode] = 850 )
    ),
    CALCULATE (
        SUM ( Table[Ave Census] ),
        FILTER ( Table, Table[FacilityCode] = 850 )
    )
)