Table Fixed last 2 Years from Today

[marcio_fornari]

Hi,

It's possible fixed my table with only last 2 years ignoring External filters of my Calendar?

When i filter the month for example (march), the table filter all years to selected month, but i don't want this.. 

i Want "to freeze" the table with all months to my last 2 years from today ignoring the filters. 

My measures:

measure 1:
Receita R$ = sum(F_ODO[VALUE])

measure 2:
Total de Atendimentos = distinctcount(F_ODO[id_odo])

measure in the table:
Fixed = DIVIDE([Receita R$],[Total de Atendimentos])

Relationship is D_CALENDAR[DATE] ----> F_ODO[DATE]

[tackytechtom · Accepted solution]

Hi @marcio_fornari ,

A quick fix might be to tweak the interaction of your slicer with the visual:

For this click on the slicer, then under format you should be able to find the button edit interaction. Finally, click on the stop/none symbol. Now the slicer won't be having any effect on your visual.

Let me know if this helps!

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[marcio_fornari]

Hi @tackytechtom it's work! Thank you so much.

With Dax it's possible?