Filtering / conditions

[KatkaS]

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

[jdbuchanan71 · Accepted solution]

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]

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