Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I want to know how to show the name of product with the highest sales.
Here is data:
I want to show for example Top Sales : "Iphone"
Thanks for help
Solved! Go to Solution.
You'd better create calculated columns to get the max sale for each group, then create a new table to display what you want. I try to reproduce your scenario and get expected result as follows.
First, create a calculated column using the following formula.
Then click the New table under Modeling, type the DAX and create a new table. Please the result in screenshot, the result table will refresh when your data refresh.
You can then use filters to identity the top products. Please let me know if this resolves your issue.
Do you want to just rank this list or remove the other options? If you want to rank items you can do this through the topN filter. Example below
@Anonymous remove all other options I want to show the name of the product with the highest sum of sales .
as I said what I want to show is for example a text Top sales : " Iphone"
I created a measure that show the sub_product with the highest sales but not the sum of sub_products;
You'd better create calculated columns to get the max sale for each group, then create a new table to display what you want. I try to reproduce your scenario and get expected result as follows.
First, create a calculated column using the following formula.
Then click the New table under Modeling, type the DAX and create a new table. Please the result in screenshot, the result table will refresh when your data refresh.
You can then use filters to identity the top products. Please let me know if this resolves your issue.
@Anonymous not that's what i want.
I want the sum of sub_products of the same product then show the highest sales between products as it explained in the picture
@Anonymous
Thanks you gave me an idea and now it works, I put sum instead of max then i worked with measures and now it works thanks
That's great news, I am glad you were able to find the solution!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |