Date filter selection issue

[JYOCH]

Hi All,

I have a situation....

I have a date filter and have a dax measure written to get result based on the filter selection. the filter is working fine if i select one month or more than a month but doesnt work if i select few days like 10 or 5 or 16 days. below are the measure and the filter

OOS FIL Cantidad Entregada =

VAR DiasDelMes=

    SWITCH(

        MONTH('All Data'[Fecha]),

        1,31,

        2, 29,

        3, 31,

        4, 30,

        5, 31,

        6, 30,

        7, 31,

        8, 31,

        9, 30,

        10, 31,

        11, 30,

        12, 31)

RETURN

DIVIDE('All Data'[Fill Cantidad Entregada], DiasDelMes)

Kindly help

[JYOCH]

I want to show a table with measures i created values like out of stock percentage,entire volume. The values are populating properly when i select one complete month but when i select few dates like 15 days from my calender, the values are not coming out properly.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[lbendlin]

Why not do a COUNTROWS(Dates) ?

What is your expected outcome ?