Help with fact table and Date dim

[jtejada]

I have a fact table called FACTURA, it has two date columns ("Sale Date" and "Expire Date), when I associate the "sale date" column with my date in the Calendar table, nothing happens. It does not work.

In the image the sales for each month should appear. And only the total comes out. If I filter by month, nothing is calculated.

When I test the calendar table with the "expire date" column, it does work for me.

In the image it shows the behavior that I want, but not with the "expiration date" column, but with "sale date"

I have analyzed the "Sales date" column and everything seems fine, field type, configuration, etc.

[Ahmedx]

pls see  this

https://community.powerbi.com/t5/Desktop/DAX-Formular-count-days-over-month-between-two-days/m-p/313...
https://community.powerbi.com/t5/Desktop/How-to-count-the-number-of-active-contracts-per-month-when-...