Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculate measure that does not equal

Hi I'm trying to calculates Fee where it is not a certain person and not on a certain date

 

Measure = CALCULATE(SUM(Query1[Billed Fees]),FILTER(Query1,Query1[WFE]<>"Karrie" ||Query1[Work Date]<>"12/29/2021"))
Need Help
  • VahidDM's avatar
    VahidDM
    4 years ago

    HI Anonymous 

     

    Try this:

     

    Measure =
CALCULATE (
    SUM ( Query1[Billed Fees] ),
    FILTER (
        Query1,
        Query1[WFE] <> "Karrie"
            && Query1[Work Date] <> DATE ( 2021, 12, 29 )
    )
)

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/

     

     

2 Replies

  • VahidDM's avatar
    VahidDM
    Icon for Super User rankSuper User
    4 years ago

    HI Anonymous 

     

    Try this:

     

    Measure =
CALCULATE (
    SUM ( Query1[Billed Fees] ),
    FILTER (
        Query1,
        Query1[WFE] <> "Karrie"
            && Query1[Work Date] <> DATE ( 2021, 12, 29 )
    )
)

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/