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.
Hello and I'm asking for help
I need to build a measure that will determine the number of average transactions for a customer and a product that is greater than the assumed parameter, and I have a big problem with it.
The data structure is as follows:
We have two customers (1 and 2) and two products (A and B). Customer A completed 3 sales transactions for product A. Customer B completed two sales transactions for product A and two for product B.
I built a measure that calculates the average transaction value for the customer and the product:
I need to build a measure that will determine the number of average transactions for the customer and product greater than the assumed parameter. For example, for parameter "5" the number of average transaction values will be 2 (2 A and 2 B), for parameter “8” the number of average transaction values will be 1 (2 A).
So far all my attempts to build such a measure have ended in failure, although it seems like it should be simple......?
Please help
Solved! Go to Solution.
Thank you very much, everything works, I'm testing the efficiency of the proposed solution
Regards
Thank you very much, everything works, I'm testing the efficiency of the proposed solution
Regards
Hi,
Here is one way to do this:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Proud to be a Super User!
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
11 | |
11 | |
10 | |
6 |