Ignore a slicer but consider another on the same page

[WTAS80486]

I have a table called Order, with columns Order, Reported date, Finish Date etc.I want to create a dax mesure to calculate Total no of workorders in that table such that the measure when pulled in a visual to show total orders should change with Reported date slicer but it should not affected by a Finish Date slicer on the same page.

For example slicer on Finish date shows date from 1/29/2024 to 1/31/2024 and total orders created as 103 which is actually for any reported date on or after 1/29/2024, now when date on slicer for Finish Date is chnaged to 1/30/2024-1/31/2024 it should still show 103 and same 103 for finish date 1/29/2024 to 1/31/2024

I need to have another measure in the same visual which calculates orders which are closed and completed and this measure should be affected by Finish date slicer and not the reported date slicer

[v-kongfanf-msft]

Hi @WTAS80486 ,

Based on your description, you can try to implement this using the edit interactions feature: create separate report date and finish date date slicers and let them filter the specified visual.

For more details, you can read below document:

Change how visuals interact in a report - Power BI | Microsoft Learn

Best Regards,
Adamk Kong

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

[WTAS80486]

I need to use finish date and reported date from the same table. calculate total orders so that it is not affected by finish date slicer but is affected by reported date. just the reverse for another measure to calculate completed orders(order status =COMP) . should change with finish date slicer  but not with reported date. both these measures have to be used in a column chart to show total orders and completed orders

[v-kongfanf-msft]

Hi @WTAS80486 ,

You can try formula like below:

TotalOrders =
CALCULATE ( COUNTROWS ( Orders ), ALL ( 'Orders'[FinishDate] ) )

CompletedOrders =
CALCULATE (
    COUNTROWS ( Orders ),
    'Orders'[OrderStatus] = "COMP",
    ALL ( 'Orders'[ReportedDate] )
)

Best Regards,
Adamk Kong

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

[WTAS80486]

My issue is I have to use two measures in the same visual and the first measure should not be affected by finish date but the second one should be affected by finish date so I cannot disconncet the visual from slicer.same for reported date, first ne should be affected by reported date and 2nd measure should not be affected.

[WTAS80486]

.

[amitchandak]

@WTAS80486 , Create an independent/Disconnected table and use that filter finish date , close or completed date as per need

[WTAS80486]

I need to use finish date and reported date from the same table. calculate total orders so that it is not affected by finish date slicer but is affected by reported date. just the reverse for another measure to calculate completed orders(order status =COMP) . should change with finish date slicer  but not with reported date. both these measures have to be used in a column chart to show total orders and completed orders