DAX Ignore external filter but apply a filter related to the external filter.

[sliceNdiceUup]

Hi guys,

I am not sure if anything as such is possible. I would like to have a report that contains both monthly and quarterly movement data with a monthly slicer .

In a way that when I apply the monthly filter/slicer for march 2021 "202103" (YYYYMM) the quarterly measure will show me all the transactions/movements for the entire quarter in which the month belongs to Q1 of 2021: "20211" (YYYYQ) which is made up of data for Jan, Feb & March.

If I apply "202104" on the slicer for April the quarterly Measure will show me all the movements that are within 2021

I can only fully ignore the external filter with the ALL()  formula, as soon as I try putting anything to filter2 position of calculate it applies the exernal Montly slicer.

Respective Q Movement:=CALCULATE(sum([Movement]),ALL('Period Table'))

PS and I don't have a date table. Period table key elment is YYYYMM value data.

[amitchandak]

@sliceNdiceUup , with a date table and time intelligence you can get that

if needed you can get a date like

Date = date(left([Monthyear],4), right([monthyear],2),1)

example

QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(('Date'[Date])))
Last QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(dateadd('Date'[Date],-1,QUARTER)))

Last QUARTER Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD( ENDOFQUARTER(dateadd('Date'[Date],-1,QUARTER))))
Last QUARTER Sales = CALCULATE(SUM(Sales[Sales Amount]),PREVIOUSQUARTER(('Date'[Date])))

Power BI — Qtr on Qtr with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
https://www.youtube.com/watch?v=8-TlVx7P0A0