topic Effective dealer sales in DAX Commands and Tips

Effective dealer sales

SachinNamdeo-20 — Tue, 13 Dec 2022 06:57:22 GMT

''I want to calculate effective dealer sales where effective dealer is those person which have 3 month avarage sales is greater than 40 whrere 3 month avarage sale is ''

3mth avarage sales = CALCULATE(SUM(CUBE_INVOICE[INVOICE QUANTITY]),DATESINPERIOD(CUBE_INVOICE[D DATE.FULLDATE],LASTDATE(CUBE_INVOICE[D DATE.FULLDATE]),-3,MONTH))/3

From this i calculate the count of effective dealer from this measure

Effective Dealer Count = SUMX( VALUES( CUBE_INVOICE[SOLD TO PARTNER.PARTNER CODE]), IF ( [3mth avarage sales] > 40, 1))

now i want to calulate only sales of these dealer as like this but this the form of table i want to calcualte this sale only with measure ho please help

kjkk

dealer	effective dealer	effective dealer sale
1
2	2	100
3	3	2000

Re: Effective dealer sales

lbendlin — Mon, 12 Dec 2022 00:01:55 GMT

Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Effective dealer sales

SachinNamdeo-20 — Tue, 13 Dec 2022 06:58:03 GMT

ok done please reply

Re: Effective dealer sales

lbendlin — Tue, 13 Dec 2022 15:17:03 GMT

did you mean to include a link?