cancel
Showing results for
Did you mean:
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: | |
Highlighted
Frequent Visitor

Hi @v-shex-msft,