cancel
Showing results for
Did you mean:
Regular Visitor

## Count numbers based on two conditions for OR statement

Hello,

I have three tables, join with order ID on 1:1 relationship.

Table A has all orders information

Table B has orders that are scaned as late

Table C has oerder that are repored as late

(so B and C may has same order ID, same you can report it as late but at the same time report it as late)

so I want to count in Table A, how many unqiue orders are scaned as late or report as late

I don't know how to do that, but I tried tha following formula, it gives me the number, just want to make sure if there any another good solution or I am lucky to get the best one?

Lates=CALCULATE(DISTINCTCOUNT('A'[SALE_ID]),filter('A',RELATED(C[Report_Late])<>blank()||RELATED(B[LATE_FLAG])="Y"))

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

## Re: Count numbers based on two conditions for OR statement

HI @NoobAnalyst01,

I'd like to suggest you use below measure to get matched row count:

```distinc =
COUNTROWS (
FILTER (
ALL ( TableA ),
TableA[SALE_ID]
IN UNION (
INTERSECT ( VALUES ( TableA[SALE_ID] ), VALUES ( TableB[SALE_ID] ) ),
INTERSECT ( VALUES ( TableA[SALE_ID] ), VALUES ( TableC[SALE_ID] ) )
)
)
)
```

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

For learning resources/Release notes, please visit: | |
Community Support Team

## Re: Count numbers based on two conditions for OR statement

HI @NoobAnalyst01,

I'd like to suggest you use below measure to get matched row count:

```distinc =
COUNTROWS (
FILTER (
ALL ( TableA ),
TableA[SALE_ID]
IN UNION (
INTERSECT ( VALUES ( TableA[SALE_ID] ), VALUES ( TableB[SALE_ID] ) ),
INTERSECT ( VALUES ( TableA[SALE_ID] ), VALUES ( TableC[SALE_ID] ) )
)
)
)
```

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

For learning resources/Release notes, please visit: | |

Announcements

#### Back to School Contest

Engage and empower students with Power BI!

#### Watch Sessions On Demand!

Continue your learning in our online communities.

#### Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

#### PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 304 members 3,115 guests
Recent signins: