filter does not work when columns are not selected

I have the following filter created filter_dates_general = VAR result = IF( SELECTEDVALUE(fct_revenue[Start_Date])>= MIN(dim_calendar[Date]) &&SELECTEDVALUE(fct_revenue[Start_Date])<=MAX(dim_cal...

rjobaan
1 year ago
that is not working. finally i find the correct code:
filter_dates_general =
VAR SelectedStartDate = MIN(dim_calendar[Date])
VAR SelectedEndDate = MAX(dim_calendar[Date])
RETURN
CALCULATE(
DISTINCTCOUNT(fct_revenu[DIM_Customer_ID]),
KEEPFILTERS(
(fct_revenu[Start_Date] >= SelectedStartDate && fct_revenu[Start_Date] <= SelectedEndDate) ||
(fct_revenu[End_Date] >= SelectedStartDate && fct_revenu[End_Date] <= SelectedEndDate) ||
(fct_revenu[Start_Date] <= SelectedStartDate && fct_revenu[End_Date] >= SelectedEndDate)
)
)

rjobaan

Frequent Visitor

1 year ago

but now it doesnt taken into account the values of the slicer right?

when i used above filter on the pie-chart with filter=1 its showing nothing

Anonymous

Not applicable

1 year ago

Thanks for the reply from Kedar_Pande , please allow me to provide another insight:

Hi, rjobaan

Based on my testing, I recommend modifying your measure as follows:

filter_dates_general = 
VAR MinDate = MIN(dim_calendar[Date])
VAR MaxDate = MAX(dim_calendar[Date])
VAR result =
    IF(
        (MAX(fct_revenue[Start_Date]) >= MinDate && MAX(fct_revenue[Start_Date]) <= MaxDate) ||
        (MAX(fct_revenue[End_Date]) >= MinDate && MAX(fct_revenue[End_Date]) <= MaxDate) ||
        (MAX(fct_revenue[Start_Date]) <= MinDate && MAX(fct_revenue[End_Date]) >= MaxDate),
        1,
        0
    )
RETURN result

Although in DAX, the && (AND) operator has a higher precedence than the || (OR) operator, it is advisable to ensure each logical condition is correctly enclosed in parentheses for accuracy and readability. This helps avoid any issues with logical operation precedence.

Here is my test example:

Test results are as follows:

Before using the measure as a filters:

After using the measure as a filters:

Currently, no issues have appeared in my test results.

Can you share sample data and sample output in tabular format if I am misunderstanding? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

For questions about uploading data, you can try the following links:

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Solved: How to upload PBI in Community - Microsoft Fabric Community

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

date.pbix67 KB