topic Re: Ignore a slicer but consider another on the same page in DAX Commands and Tips

Ignore a slicer but consider another on the same page

WTAS80486 — Thu, 01 Feb 2024 22:39:52 GMT

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

Re: Ignore a slicer but consider another on the same page

amitchandak — Fri, 02 Feb 2024 06:45:07 GMT

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

Re: Ignore a slicer but consider another on the same page

Anonymous — Fri, 02 Feb 2024 06:57:24 GMT

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.

Re: Ignore a slicer but consider another on the same page

WTAS80486 — Fri, 02 Feb 2024 14:07:24 GMT

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.

Re: Ignore a slicer but consider another on the same page

WTAS80486 — Fri, 02 Feb 2024 14:24:16 GMT

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

Re: Ignore a slicer but consider another on the same page

WTAS80486 — Fri, 02 Feb 2024 14:25:49 GMT

Re: Ignore a slicer but consider another on the same page

WTAS80486 — Fri, 02 Feb 2024 14:25:20 GMT

Re: Ignore a slicer but consider another on the same page

Anonymous — Thu, 22 Feb 2024 09:07:39 GMT

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.