Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello again,
This is my second time posting this questions, after the first one kicked me out when posting. I'm very new to Power Bi and Dax is completely foregn to me. I'm not sure how to properly ask this question other than by explaining what I am trying to do.
Okay. I have multiple customers (A, B, C), that purchased mutliple products (X, Y, Z), in different months (Jan 2020, Feb 2020, etc), and each customer has a non-return rate (0.8, 0.85, 0.9) that the product and date have no impact on. I would like to graph the non-return rate for each customer by product by month.
Below is some sample data. In this example. Customer A bought 10 X product in January 2020. They have a non-return rate of 0.8, and therefore I would expect them to return 2 of the 10 I sent them. I would like to graph the 8, that I sent them. I would like to do this for all the products and each month. I for the life of me can't search the right terms to figure this out.
Thanks in advance, a frustrated Bi beginner.
Customer | Date | Product | Non-Return Rate |
A | 1/1/20 | X | 0.8 |
A | 1/1/20 | X | 0.8 |
A | 1/1/20 | X | 0.8 |
A | 1/1/20 | X | 0.8 |
A | 1/1/20 | X | 0.8 |
A | 1/1/20 | X | 0.8 |
A | 1/1/20 | X | 0.8 |
A | 1/1/20 | X | 0.8 |
A | 1/1/20 | X | 0.8 |
A | 1/1/20 | X | 0.8 |
A | 2/1/20 | X | 0.8 |
A | 2/1/20 | Y | 0.8 |
B | 1/1/20 | X | 0.85 |
B | 1/1/20 | Z | 0.85 |
C | 1/1/20 | X | 0.90 |
C | 2/1/20 | Y | 0.90 |
Solved! Go to Solution.
Hi @erenner ,
Based on your data believe that the return rate is always the same for each customer so you can do the following measure:
Non Return = COUNT('Table'[Product]) * AVERAGE('Table'[Non-Return Rate])
Be aware that now what comes into action is the way you build your chart. Has you can see in the table below you have a return rate of 8 for january product X customer A then if you select the value in a slicer the line chart returns the correct value.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @erenner ,
Based on your data believe that the return rate is always the same for each customer so you can do the following measure:
Non Return = COUNT('Table'[Product]) * AVERAGE('Table'[Non-Return Rate])
Be aware that now what comes into action is the way you build your chart. Has you can see in the table below you have a return rate of 8 for january product X customer A then if you select the value in a slicer the line chart returns the correct value.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
82 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |