Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
tanguy0807
New Member

Use a measure in a Segment filter

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) :

 

Segment_filter.png

 

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.question_power_bi.pngI 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.

1 REPLY 1
v-caliao-msft
Employee
Employee

@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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.