Forum Discussion
TOP 5 SALES
Hi team , i want to calculate top 5 sales ASO top5 is calculation calculate sales based on flag=y and top5 target ASM top5 is calculation calculate sales based top5 sales from ASO TOP5 BM top...
1. ASO Top 5 Sales
ASO Top 5 Sales =
VAR TopASO =
TOPN(
5,
SUMMARIZE(
DealerData,
DealerData[ASO],
"ASO Sales", SUM(SalesData[Sales])
),
[ASO Sales],
DESC
)
RETURN
CALCULATE(
SUM(SalesData[Sales]),
KEEPFILTERS(TopASO),
DealerData[Flag] = "Y"
)
2. ASM Top 5 Sales
ASM Top 5 Sales =
VAR TopASM =
TOPN(
5,
SUMMARIZE(
DealerData,
DealerData[ASM],
"ASM Sales", [ASO Top 5 Sales]
),
[ASM Sales],
DESC
)
RETURN
CALCULATE(
[ASO Top 5 Sales],
KEEPFILTERS(TopASM)
)
3. BM Top 5 Sales
BM Top 5 Sales =
VAR TopBM =
TOPN(
5,
SUMMARIZE(
DealerData,
DealerData[BM],
"BM Sales", [ASM Top 5 Sales]
),
[BM Sales],
DESC
)
RETURN
CALCULATE(
[ASM Top 5 Sales],
KEEPFILTERS(TopBM)
)
If this helped, a Kudos 👍 or Solution mark would be great!🎉
Cheers,
Kedar Pande
Connect on LinkedIn
ASO Top 5 Sales =
VAR TopASO =
TOPN(
5,
SUMMARIZE(
DealerData,
DealerData[ASO],
"ASO Sales", SUM(SalesData[Sales])
),
[ASO Sales],
DESC
)
RETURN
CALCULATE(
SUM(SalesData[Sales]),
KEEPFILTERS(TopASO),
DealerData[Flag] = "Y"
)
I this measure top 5 sales only calculating.
but i need to calculate the sales of flag=y and top5 target