Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |