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.
Source Table
Date | Category | customore name | Sales |
4/6/2021 | Equity | a | 123 |
4/6/2021 | Equity | b | 345 |
4/6/2021 | Equity | c | 567 |
4/6/2021 | Equity | d | 789 |
4/6/2021 | Equity | e | 1011 |
4/6/2021 | Equity | f | 1233 |
4/6/2021 | Equity | g | 1455 |
4/6/2021 | Equity | h | 1677 |
4/6/2021 | Equity | i | 1899 |
4/6/2021 | Equity | j | 2121 |
4/6/2021 | Equity | k | 2343 |
4/6/2021 | Equity | l | 2565 |
4/6/2021 | Commodity | d | 453 |
4/6/2021 | Commodity | e | 564 |
4/6/2021 | Commodity | f | 234 |
4/6/2021 | Commodity | g | 453 |
4/6/2021 | Commodity | h | 564 |
4/6/2021 | Commodity | i | 234 |
4/6/2021 | Commodity | a | 399 |
4/6/2021 | Commodity | b | 564 |
4/6/2021 | Commodity | c | 729 |
5/6/2021 | Equity | g | 894 |
5/6/2021 | Equity | h | 1059 |
5/6/2021 | Equity | i | 1224 |
5/6/2021 | Equity | j | 342 |
5/6/2021 | Equity | l | 1554 |
5/6/2021 | Equity | d | 1719 |
5/6/2021 | Equity | e | 1884 |
5/6/2021 | Equity | f | 2049 |
5/6/2021 | Equity | g | 2214 |
5/6/2021 | Equity | h | 234 |
5/6/2021 | Equity | i | 2544 |
5/6/2021 | Equity | k | 2565 |
I need a top 3 customer name by sales and filtered by category and date divided by total sales filtered by category and date
eg. date 4/6/2021 top 3 customer sales =7029 for category equity divided by totalsales of equity category and date4/6/2021 is 16128
o/p= 7029/16128
= 44%
Solved! Go to Solution.
Hi @Anshenterprices ,
Please use the following measure:
Measure = DIVIDE(SUMX(TOPN(3,'Table',CALCULATE(SUM('Table'[Sales]))),'Table'[Sales]),SUM('Table'[Sales]))
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi @Anshenterprices ,
Please use the following measure:
Measure = DIVIDE(SUMX(TOPN(3,'Table',CALCULATE(SUM('Table'[Sales]))),'Table'[Sales]),SUM('Table'[Sales]))
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
For your measure, You can use TOPN Dax formula to calculate the top 3 customer names by sales.
Regards,
Mintu Baruah
If you find the solution useful please mark my post as a solution!
In doing so, you are also helping me. Thank you!
@Anshenterprices , Try a measures like
Sales M = sum(Table[Sales])
CALCULATE([Sales M],TOPN(10,allselected(Table[Customer]),[Sales M],DESC),VALUES(Table[Customer]))
Covering 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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |