Calculated measure not showing by month

[dawnc63]

Why does this measure only show up in a table if I show all dates (daily) and not when I show the month only?

Current Period Interest =

    CALCULATE( [Daily interest],

        ALLSELECTED(Dates[Date]),

        DATESBETWEEN('Dates'[Date],STARTOFMONTH(Dates[Date]),ENDOFMONTH(Dates[Date])))

I'm trying to show the total of the interest calculated for each month.
The correct daily calculated amount shows when I add the "dates" column from my dates table.

[v-gizhi-msft · Accepted solution]

Hi,

According to your description, I create a table to test as follows.

And I create a measure as this.

The result:

If you still have questions, please for free to let me know.

Best Regards,

Giotto Zhi

[dawnc63]

Thank you for your help.  I will give it a try and report back!