date range issue

[Anonymous]

I've a data model like the screenshot

here're the relationships between tables

I try to calculate count application by next_processing_date

Anta = calculate( sum(proposals[CountApplication]) , USERELATIONSHIP( proposals[next_processing_date] , DimDate[Date] ),FILTER(proposals, proposals[next_processing_date] >= 'Report Measures'[StartDate]&&proposals[next_processing_date] <= 'Report Measures'[endDate]))

But it returns always nothing

I analyze data it seems the issue related to the expresion of measure, how to correct it

[v-kkf-msft · Accepted solution]

Hi @Anonymous ,

I think in your formula, the [created_date] column filter is also applied, resulting in a blank result. Please try using the following formula.

Anta =
CALCULATE (
    SUM ( proposals[CountApplication] ),
    USERELATIONSHIP ( proposals[next_processing_date], DimDate[Date] ),
    FILTER ( DimDate, DimDate[Date] >= [StartDate] && DimDate[Date] <= [endDate] )
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[speedramps]

Your screen shot hides Report Measures'[StartDate] and Report Measures[endDate].

Are they field or measure. Do they all have a date data type?

Try debug dmall section of your measure one at a time ... for example ....  😁😁😁

Debug 1=
calculate(

sum(proposals[CountApplication]) ,

USERELATIONSHIP( proposals[next_processing_date] , DimDate[Date] )
)

Debug 2=
COUNTROW(

FILTER(proposals,

proposals[next_processing_date] >= 'Report Measures'[StartDate] &&

proposals[next_processing_date] <= 'Report Measures'[endDate])
)

[Anonymous]

Both expressions return values,

[Anonymous]

when I switch active/inactive relationship betrween proposal and date, it returns correctly results