Forum Discussion

KatkaS's avatar
KatkaS
Post Patron
6 years ago
Solved

Filtering / conditions

 

Hello,

could anyone help me here please? I've spent hours on a (I think) simple logic query, but I'm not able to get the right results:(((

 

I need to calculate number of invoices (lines), that

1. have a number > 0 in column A

2. AT THE SAME TIME have number 0, if in column B there is EDIAUTO

Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    Hello KatkaS 

    I believe this will give you what you are looking for.

    Measure = 
CALCULATE(
    COUNTROWS ( 'Table' ),
    FILTER ( 'Table',
    'Table'[PHWSID] = "EDIAUTO" || 'Table'[APPORD] > 0
    )
)

    This will count every row in the table where
    [PHWSID] = "EDIAUTO" 

    or

    [APPORD] > 0

2 Replies

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    6 years ago

    Hello KatkaS 

    I believe this will give you what you are looking for.

    Measure = 
CALCULATE(
    COUNTROWS ( 'Table' ),
    FILTER ( 'Table',
    'Table'[PHWSID] = "EDIAUTO" || 'Table'[APPORD] > 0
    )
)

    This will count every row in the table where
    [PHWSID] = "EDIAUTO" 

    or

    [APPORD] > 0

    • KatkaS's avatar
      KatkaS
      Post Patron
      6 years ago

      Ohmy, thank you so much for such a quick reply!!! You saved my sanity!!!!!