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
arhomberg
Helper I
Helper I

Using Results of a Measure to Limit another Measure

Hey everyone,

 

I am working to see if its possible to use the result of one calculation in the filter of another?

 

My end goal is to calculate year over year retention rates by calculating the revenue from a year ago, and of that revenue form a year ago, how much of it (maybe more) exists today.

 

I currently have this measure that I can use to calculate last years revenue.

 

arhomberg_0-1661972323988.png

 

I am finding the sum of the transaction value over the filtered period of time, in this cause the month of a year ago.

Is there a way to use the results of the above measure (so if I apply it to a customer by customer basis), to see how each exists today?

 

My idea looked something like this:

 

arhomberg_1-1661972323992.png

 

Basically, filter the new (current) measure to ensure that it is only calculating for those that were present in last year’s calculation.

 

Any guidance with this would be greatly appreciated, thanks!

 

Regards,

 

Alex

2 REPLIES 2
Anonymous
Not applicable

Hi @arhomberg ,

 

The first measure returns a single numeric value, if you want use it in second measure, you should use "=" instead of "IN".

 

Best Regards,

Jay

Hello @Anonymous ,

 

Is it possible in DAX to have a measure return a value set? In this case, have the SUM MRR LY measure return a vector/list of a field where the filter applies for the variable. For each month, I want to get a list of the customers that had active transactions a year ago, and the essentiall do a right join to these customers in the SUM MRR TY measures filter.

 

Thanks,

 

Alex

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.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.