Fixed sliced date in a column without chage by row context

[thiagocamillo]

Hi,

I need help to fixed a date sliced on a colum without change contex by rows.

I tried ALL, ALLSELECTED, ALLEXCEPTED.... but i did't have the expected result.

I would appreciate if anyone can help

-----------------

Calc. Data de Referencia (IRC) =

var vIS =

CALCULATE(

MIN(DimData[Date]),

ALLSELECTED(DimData[Date])

)

return

vIS"

------------------

[thiagocamillo · Accepted solution]

For the solution of this case I wached this video Power BI From and To Date Filtering with One Slicer - YouTube

  and before pubished this arcticle to my especific preoblem.

Modelo para analise de dados em Power BI (DAX) analisando o contexto de intervalo de tempo ou duas d...

[thiagocamillo]

Hi, @amitchandak 

thanks but it still didn't work as expected, the date is now with the general minimum, not following the slicer. (Ex. Slicer 01/04/2022 and data 01/01/2021 (Minimum of dimdata)

[amitchandak]

@thiagocamillo , try like

Calc. Data de Referencia (IRC) =
var vIS =
CALCULATE(
MIN(DimData[Date]),
ALLSELECTED(DimData)
)
return
vIS

or

Calc. Data de Referencia (IRC) =
var vIS =
CALCULATE(
MIN(DimData[Date]),
ALLSELECTED()
)
return
vIS