Use a measure in a Segment filter

[tanguy0807]

I am trying to use a measure in a Segment filter, the measure being calculated from the output of another Segment filter. However, Segment filters do not accept measures as input and I did not find any solution to retrieve the desired value without using a measure. Just to make things clear, here is what I mean by a Segment filter (in the yellow box) :

Below is an screenshot of what I am trying to do: I would like the second Segment filter to use the mininum [Beginning Date] (in this case: 14/11/2016) as a treshold and keep only lines with [End Date] smaller than this threshold.I have used the following formula to retrieve this minimum [Beginning Date] (both columns, [Beginning Date] and [End Date] are in my table called Organisation😞 

Min_Beginning_Date = CALCULATE(max(Organisation[Beginning Date]), FILTERS(Organisation[Beginning Date]))

(Note: I do not actually get the value of the threshold in the first Segment filter. Instead, I get the minimum value from Organisation[Beginning Date] filtered above that threshold. If someone had an idea to get the actual threshold, I would be grateful for that)

The problem is that Min_Beginning_Date is a measure, and can not be used in a Segment filter. Therefore, I did not manage to set my second Segment filter dynamically.

Any help appreciated.

[v-caliao-msft]

@tanguy0807,

Slicer visual cannot accpet a measure. And we cannot add filter to Slicer visual. So I am afraid there is no any workaround to achieve this requirement in current version of Power BI.

Thank you for your understanding.

Regards,

Charlie Liao