cancel
Showing results for
Search instead for
Did you mean:
Highlighted
Helper V

## ND Number of rows with Units OR SOH greater than 0

Hi there,

I am trying to calculate the number of rows that have either Units or Stock greater than zero in the last 2 months.

Units and Stock are in my fact table.

Fact table has the following columns Date, ProdID, StoreID, Units, Stock

I also have a calendar table.

The result I am looking for is the number of rows in the fact table that has either Units OR Stock in the last 2 Months.

My fact table is rather larger so I cant add a calculated column.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support

## Re: ND Number of rows with Units OR SOH greater than 0

You may refer to the following measure.

```Measure =
VAR y =
YEAR ( TODAY () )
VAR m =
MONTH ( TODAY () )
RETURN
COUNTROWS (
FILTER (
'Fact',
'Fact'[Date]
>= DATE ( y, m - 1, 1 )
&& ( 'Fact'[Units] > 0
|| 'Fact'[Stock] > 0 )
)
)
```
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Highlighted
Community Support

## Re: ND Number of rows with Units OR SOH greater than 0

You may refer to the following measure.

```Measure =
VAR y =
YEAR ( TODAY () )
VAR m =
MONTH ( TODAY () )
RETURN
COUNTROWS (
FILTER (
'Fact',
'Fact'[Date]
>= DATE ( y, m - 1, 1 )
&& ( 'Fact'[Units] > 0
|| 'Fact'[Stock] > 0 )
)
)
```
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper V

## Re: ND Number of rows with Units OR SOH greater than 0

Awesome - thank you @v-chuncz-msft || is Just want I needed.

## Helpful resources

Announcements

#### Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

#### August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

#### July 2020 Community Highlights

Learn about the exciting things that happened in July.

#### Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

#### Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors