Forum Discussion

Marcus_E's avatar
Marcus_E
Icon for Helper I rankHelper 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")

Marcus_E's avatar
Marcus_E
Icon for Helper I rankHelper I
6 years ago

Thank you, both of these solutions work perfectly.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

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