How to make different Date Filters for different visuals on the same page?

[artjomsf]

I have Date-Table and several related tables with monthly data (e.g. - monthly sales in one, monthly expenses in the another, etc.). I want to be able to select one month in a filter and show the visuals with the relevant data on per month basis for selected month and two upcoming months, e.g.:

I select March on the right and have 3 different cards: March, April and May. I've currently done it with the Measures:

nextMonthValue1 = CALCULATE(SUM(table[Value]), NEXTMONTH(DateTable[Date])) // for the next month

nextMonthValue2 = CALCULATE(table[nextMonthValue1], NEXTMONTH(DateTable[Date])) // for the 2 months in future

 I could do measures for each value I need, but there are many of them and it does not look practical to have so many small measures. Is there a chance to get it working more smoothly?

Thanks! 

[amitchandak · Accepted solution]

@artjomsf ,

Calculation Groups, so that you can do it with fewer measures

calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/

also this need to be

nextMonthValue2 = CALCULATE(table[nextMonthValue1], NEXTMONTH(dateadd(DateTable[Date],1,month) )) 

The other way is the independent table when select one month and show more than that

refer

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

[artjomsf]

Thanks! I am certainly check this out closely, the Independent Date Table sounds exactly what I am looking for. Cheers!