Using Results of a Measure to Limit another Measure

[arhomberg]

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.

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:

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

[v-jayw-msft]

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

[arhomberg]

Hello @v-jayw-msft ,

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