Forum Discussion

jeronimo2334's avatar
jeronimo2334
Helper III
5 years ago

Dax Table Filterting

Hello all,   I have a table like so:   I have connected it to a date table all the start and thru columns on the right side are connecting to the Date column on the left:   And I crea...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi jeronimo2334 ，

 

I made a simple sample as below:

Create a measure as below:(Be sure that if you wanna use a measure to filter data,you'd better remove the relationship between the key fields)

 

measure = 
var _maxdate=CALCULATE(MAX('Date'[Date]),ALLSELECTED('Date'[Date]))
var _mindate=CALCULATE(MIN('Date'[Date]),ALLSELECTED('Date'[Date]))
var _tab= CALCULATETABLE(VALUES('Table'[Crstart]),FILTER(ALL('Table'),'Table'[Crstart]<=_mindate&&'Table'[Crthur]>=_maxdate))
Return
IF(MAX('Table'[Crstart]) in _tab,MAX('Table'[Crstart]),BLANK())

 

And you will see:(put measure into filter pane and select measure is not blank)

For the related .pbxi file,pls see attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!