How can I Prevent Only One Filter For Only One Visual

[Anonymous]

Hi everyone,

I'm trying to build a SMS delivery dashboard for a company. 

I'm trying to calculate AVG of SMS delivery time for month, week, and day as seconds. I'm using the measure formula below.

I dont want my date filter effect this visual that im using measure below. I tried to use ALL function but it didnt work. Any help?

Thanks.

MonthAverage = CALCULATE(AVERAGE(vSmsMessageDashboardRpt[SecDifference]), FILTER(vSmsMessageDashboardRpt, FORMAT(vSmsMessageDashboardRpt[SystemDate], "dd/mm/yyyy")>= FORMAT(DATE(YEAR(TODAY()),1,1), "dd/mm/yyyy")))

[Anonymous]

I tried to use ALL function like below but it didnt work.

MonthAverage = CALCULATE(AVERAGE(vSmsMessageDashboardRpt[SecDifference]), FILTER(vSmsMessageDashboardRpt, FORMAT(vSmsMessageDashboardRpt[SystemDate], "dd/mm/yyyy")>= FORMAT(DATE(YEAR(TODAY()),1,1), "dd/mm/yyyy")), ALL(vSmsMessageDashboardRpt[SystemDate]))

[V-lianl-msft · Accepted solution]

Based on your description, maybe you don't need to change the DAX formula, just modify the interaction between the two visuals.

1. Select the Filter
2. Choose Tab "Format", click "Edit interactions"
3. Make sure the Filter still seletecd, then choose none for another visual.

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions 

[Anonymous]

Thanks for your help. It works 🙂