cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Calculate(Count (....), (Datesbetween(....)) returns nothing

Hey guys

I insert the following Measure in Power BI Desktop:

Latest_NPS = CALCULATE(COUNTA(NPS[nps_category]);DATESBETWEEN(NPS[ts];[LastestDate_NPS_Start];[LatestDate_NPS_End]))

It retunrs: Nothing

Returns_Nothing

If I insert this measure:

Latest_NPS = CALCULATE(COUNTA(NPS[nps_category]);DATESBETWEEN(NPS[ts];[LastestDate_NPS_Start];[LastestDate_NPS_Start]))

It retunrs: 1

1

Why I am not able to COUNTA the NPS[nps_category] for a specific timeline?

Simon

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

## Re: Calculate(Count (....), (Datesbetween(....)) returns nothing

Hi @SimonAbs,

You can try to use below formula to calculate records between specific date range:

```Latest_NPS =
VAR currStart =
MAX ( NPS[LastestDate_NPS_Start] )
VAR currEnd =
MAX ( NPS[LatestDate_NPS_End] )
RETURN
CALCULATE (
COUNTA ( NPS[nps_category] );
FILTER ( ALLSELECTED ( NPS ); NPS[ts] IN CALENDAR ( currStart; currEnd ) )
)
```

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: | |
2 REPLIES 2
Community Support Team

## Re: Calculate(Count (....), (Datesbetween(....)) returns nothing

Hi @SimonAbs,

You can try to use below formula to calculate records between specific date range:

```Latest_NPS =
VAR currStart =
MAX ( NPS[LastestDate_NPS_Start] )
VAR currEnd =
MAX ( NPS[LatestDate_NPS_End] )
RETURN
CALCULATE (
COUNTA ( NPS[nps_category] );
FILTER ( ALLSELECTED ( NPS ); NPS[ts] IN CALENDAR ( currStart; currEnd ) )
)
```

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: | |
Frequent Visitor

## Re: Calculate(Count (....), (Datesbetween(....)) returns nothing

Hi @v-shex-msft,

Thanks for the fast reply.

It works perfect

Best regards,

Simon

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 406 members 3,534 guests
Recent signins: