Filtering from slicer and OR logic in DAX is not able to achieve in my case

[DineshArivu]

Hi All,

Data Validation :

I am using 2 slicers (Amount in usd & churn in usd) with min & max values and few cards to display the counts based on the selected slicer values as below :

below the query which is executed from snowflake data source and the expected result is 490 , but i am getting 447 with all the filters applied in this query (using slicers in power bi report)

Snowflake query : Output - 490 row count
select * from datalake.dm_bss_oss.vw_opportunity_quote_source where sales_involvment='Sales Opportunities' and opportunity_stage='Closed Won' and closed_date between '2025-01-01'and'2025-06-30' and (amount_in_usd between '0' and '50000' or churn_in_usd between '-50000' and '0');  -- values 0,50000 and all are just a sample in this query but we have a separate slicers for the amount seelction in dashboard

DAX query : Output - 447 row count (should be 490)

CALCULATE (COUNT('Opportunity Quote Source'[SFDC_ENSONO_OPPORTUNITY]),

    FILTER (ALLSELECTED('Opportunity Quote Source'),

        (

            'Opportunity Quote Source'[AMOUNT_IN_USD] >= MIN('Opportunity Quote Source'[AMOUNT_IN_USD]) &&

            'Opportunity Quote Source'[AMOUNT_IN_USD] <= MAX('Opportunity Quote Source'[AMOUNT_IN_USD])

        )

        ||

        (

            'Opportunity Quote Source'[CHURN_IN_USD] >= MIN('Opportunity Quote Source'[CHURN_IN_USD]) &&

            'Opportunity Quote Source'[CHURN_IN_USD] <= MAX('Opportunity Quote Source'[CHURN_IN_USD])

        )))

[v-pnaroju-msft · Accepted solution]

Thankyou, @jaineshp, for your response.

Hi DineshArivu,

Thank you for your inquiry on the Microsoft Fabric Community Forum. We appreciate your follow up and apologise for the delayed response.

Based on my understanding of the scenario, please find attached a screenshot and a sample PBIX file that we hope will help resolve the issue:

We trust the information provided is helpful. If you have any further queries, please feel free to contact the Microsoft Fabric community.

Thank you.

[jaineshp]

Hey @DineshArivu,

From the images and the DAX you posted, the problem is because you’re using:

MIN('Opportunity Quote Source'[AMOUNT_IN_USD])
MAX('Opportunity Quote Source'[AMOUNT_IN_USD])

inside the same table you’re filtering. That causes context restriction — meaning Power BI only evaluates MIN/MAX on already filtered rows, so your OR logic acts like an AND in many cases.

The correct way is to:

• Take slicer values from a disconnected parameter table (for Amount and Churn separately)

• Store them in variables before filtering

• Then apply the OR logic explicitly inside FILTER

Here’s the fixed measure that will work 100% and match your Snowflake query results:

Step 1 – Create two disconnected parameter tables (via Enter Data in Power BI):

MinAmt MaxAmt
0 50000

(You can add as many ranges as you want for slicer purposes.)

MinChurn MaxChurn
-50000 0

Step 2 – Create the measure using variables:

Count Opportunities OR =
VAR MinAmt =
MINX ( ALL ( 'Amount Param' ), 'Amount Param'[MinAmt] )
VAR MaxAmt =
MAXX ( ALL ( 'Amount Param' ), 'Amount Param'[MaxAmt] )
VAR MinChurn =
MINX ( ALL ( 'Churn Param' ), 'Churn Param'[MinChurn] )
VAR MaxChurn =
MAXX ( ALL ( 'Churn Param' ), 'Churn Param'[MaxChurn] )
RETURN
CALCULATE (
COUNT ( 'Opportunity Quote Source'[SFDC_ENSONO_OPPORTUNITY] ),
FILTER (
ALLSELECTED ( 'Opportunity Quote Source' ),
(
'Opportunity Quote Source'[AMOUNT_IN_USD] >= MinAmt
&& 'Opportunity Quote Source'[AMOUNT_IN_USD] <= MaxAmt
)
|| (
'Opportunity Quote Source'[CHURN_IN_USD] >= MinChurn
&& 'Opportunity Quote Source'[CHURN_IN_USD] <= MaxChurn
)
)
)

Step 3 – Use these parameter tables as slicers instead of the original columns directly.

Why this will now match Snowflake’s 490 count:

• OR logic is preserved because each condition is evaluated independently.

• Slicer values are coming from disconnected tables, so no filter context is lost.

• Works identically to your SQL (amount between … OR churn between …) clause.

Fixed? ✓ Mark it • Share it • Help others!

Best Regards,
Jainesh Poojara | Power BI Developer

[DineshArivu]

@jaineshp  Thanks for your solution 🙂
I have a query in step 1 : MinAmt & MaxAmt is a dynamic here , user can select any range between that. so how to create parameter for all the range (even we don't know how user may select the range)