Conditional Statement

[Kaskazi_Network]

Hi all,

I have some data that consists of a wholesaler and sales reps attached to each wholesaler. Different wholesalers have a different number of sales rep attached to them. Each sales rep has a daily target of 35 visits. I need to show these daily targets against the wholesaler.

What DAX formula could I use to achieve this? Thank you.

Wholesaler	Sales reps attached	Target per Sales rep	Targets
A	2	35	70
B	3	35	105
C	4	35	140
D	5	35	175
E	4	35	140

[amitchandak · Accepted solution]

@Kaskazi_Network , Is that product of two columns ??

New column

rep Targets= [Sales reps attached]* [Target per Sales]

[Sumanth_23]

hi @Kaskazi_Network - Please look at the below steps to achieve the same using DAX

You need to create the below 3 measures to achieve the desired result. 

SalesRep = MAX('Wholesaler Targets'[Sales reps attached])

TargetPerSalesRep = MAX('Wholesaler Targets'[Target per Sales rep])

TargetPerWholesaler = 'Wholesaler Targets'[SalesRep] * 'Wholesaler Targets'[TargetPerSalesRep]

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

[Kaskazi_Network]

The last column shows Wholesaler Targets