Sum of column with condition

[Kadrimedquali]

Hi,

Good Day!

i have a dataset, i would like calculat the sum of column (Mnt Transport) but for each (N° Expédition).

fILE : link 

exemple :

for month August , the sum of Mnt transport is 382500, is not 10420200 as in the file, because the amount of (Mnt Transport )is redoubled for each row.

Sum of August is 4500+(43200*7)+(37080*2) =382500

many thinks

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[v-angzheng-msft · Accepted solution]

Hi, @Kadrimedquali 

Sum of August is 4500+(43200*7)+(37080*2) =>>4500+302400+74160=381060

try to create a measure like this:

Measure = 
var _t1=SUMMARIZE('Base export',[Date Expédition].[Mois],[Transporteur],"1",DISTINCTCOUNT('Base export'[N° Expédition]),"2",AVERAGE('Base export'[Mnt Transport]))
var _t2=ADDCOLUMNS(_t1,"3",[1]*[2])
return SUMX(_t2,[3])

 Result:

Please refer to the attachment below for details. Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Kadrimedquali]

i need help

thank you

[Kadrimedquali]

hi @VahidDM 

thank you for your colaboration

link of the file link 

[VahidDM]

HI @Kadrimedquali 

I can't downoad the file (need Access), can you share that on https://gofile.io/

Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/