Forum Discussion

Marcus_E's avatar
Marcus_E
Helper I
6 years ago
Solved

Multiple measure AND conditions

Hi   I'm trying to eliminate unnecessary slicers on my report page by filtering key outputs using measures but am struggling combining multiple AND conditions within the measure.   The scenario i...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Marcus_E , Try one of three


    Measure (Quantity Total) =
    CALCULATE (
    SUM (Transaction_Name[Quantity]) ,
    FILTER(Transaction_Name, Transaction_Name[Quantity] > 0) ,
    FILTER(Resource_Type, Resource_Type[Resource_Description] = "Contractors"))

    Measure (Quantity Total) =
    CALCULATE (
    SUM (Transaction_Name[Quantity]) ,
    Transaction_Name[Quantity] > 0 && Resource_Type[Resource_Description] = "Contractors")


    Measure (Quantity Total) =
    CALCULATE (
    SUM (Transaction_Name[Quantity]) ,
    FILTER(Transaction_Name, Transaction_Name[Quantity] > 0) , Resource_Type[Resource_Description] = "Contractors")

amitchandak's avatar
amitchandak
Super User
6 years ago

Marcus_E , Try one of three


Measure (Quantity Total) =
CALCULATE (
SUM (Transaction_Name[Quantity]) ,
FILTER(Transaction_Name, Transaction_Name[Quantity] > 0) ,
FILTER(Resource_Type, Resource_Type[Resource_Description] = "Contractors"))

Measure (Quantity Total) =
CALCULATE (
SUM (Transaction_Name[Quantity]) ,
Transaction_Name[Quantity] > 0 && Resource_Type[Resource_Description] = "Contractors")


Measure (Quantity Total) =
CALCULATE (
SUM (Transaction_Name[Quantity]) ,
FILTER(Transaction_Name, Transaction_Name[Quantity] > 0) , Resource_Type[Resource_Description] = "Contractors")

  • Marcus_E's avatar
    Marcus_E
    Helper I
    6 years ago

    Thank you, both of these solutions work perfectly.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      5 years ago

      You are welcome.  If my reply helped, please mark it as Answer.