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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
udani969
Regular Visitor

How to filter a data set by a measure output using DAX

Hi,

I have this data modal implemented so far.

 

udani969_0-1707309191103.png

 

I need to have two drop downs where selection of one drop down shortens the second drop down values. One I select a project name from the second dropdown it need to figure out the Version number of the latest release of the selected project. I could get it work up to this point by adding two slicers and below measure.

 
Latest Release Name = CALCULATE(MAX(test_execution_summary[Version]), FILTER(test_execution_summary, test_execution_summary[Executed On] = MAX(test_execution_summary[Executed On]))) ​

Rest of the calculations are based on the records filtered with this latest release name. If I can get some help to decide what should I do next in order to filter my data set based on the slicer value selection and this latest release value filtered, it would be a great help.

 

I am totally new to Power BI and still trying to get my head wrapped around how things work. 

 

1 REPLY 1
lbendlin
Super User
Super User

I need to have two drop downs where selection of one drop down shortens the second drop down values

That is a job for your data model. The first slicer must be fed by a column in the same table as the second slicer, or a column in a parent table.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.