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")

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

Hi,

Does this work?

Measure (Quantity Total) = CALCULATE(SUM('Transaction_Name'[Quantity]),FILTER('Transaction_Name', 'Transaction_Name'[Quantity]>0),FILTER('Resource_Type','Resource_Type'[Resource_Description] = "Contractors"))
If it does not help, then share the link from where i can download your PBI file.