topic Re: Date filter selection issue in Developer

Date filter selection issue

JYOCH — Mon, 08 Apr 2024 13:42:19 GMT

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

Re: Date filter selection issue

lbendlin — Tue, 09 Apr 2024 00:28:16 GMT

Why not do a COUNTROWS(Dates) ?

What is your expected outcome ?

Re: Date filter selection issue

JYOCH — Tue, 09 Apr 2024 17:03:03 GMT

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.

Re: Date filter selection issue

lbendlin — Tue, 09 Apr 2024 17:40:04 GMT

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-Forum/ba-p/963216

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/1447523