Using value from filter in DAX formula

[suchy1981]

Dear,

In my power BI report I have filter build from data. Than I create the measure like

Min Date Range ALLSELECTED col =

DATEVALUE(CALCULATE (

MIN ( allObjectsBatBuild2[date] ),

ALLSELECTED ( 'allObjectsBatBuild2')

))

and I got right value. But if I want to create column in which I want to use this measure:

iii = if(allObjectsBatBuild2[date] < allObjectsBatBuild2[Min Date Range ALLSELECTED],1,0)

it doesn't work. It means there is no error but formula if doesn't work properly. IF I will put the date like this

iii = if(allObjectsBatBuild2[date] < DATE(2021,3,16), 1,0)

all is fine. Why can't I use in IF formula allObjectsBatBuild2[Min Date Range ALLSELECTED]

Thanks for any help

[amitchandak]

@suchy1981 , You can not create a column using measure or using slicer value.

You can create a line level measure using SUMX/COUNTX, MIX etc

MINX(Table, <Code>)

In visual display, it is at the desired level.

If you need filters use bucketing

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k