How to calculate sales amount based on a team of salesmen

[Anonymous]

Hi,

Request your guidance to overcome this issue;

Our Sales team is divided to three groups A,B and C.  A team is lead by a team leader and 2 salesmen same is the order for team B and C.  In our dashboard we would like to display the total sales  of Team A, Team  B and Team C.  We are planing to use a card visual ( 3 nos ) for displaying each Teams sales.  Kindly advice how we can make this happen

regards,

dsmitha

[TomMartens · Accepted solution]

Hey @Anonymous ,

I'm sure I'm miss something.

Nevertheless, create 3 card visuals, drag the sales column to the values well of the visuals.

Add a column as a visual level filter to each card visual and filter the data accordingly:

Types of filters in Power BI reports - Power BI | Microsoft Learn

Hopefully, this provides what you are looking for.

Regards,

Tom

[TomMartens · Accepted solution]

Hey @Anonymous ,

I'm sure I'm miss something.

Nevertheless, create 3 card visuals, drag the sales column to the values well of the visuals.

Add a column as a visual level filter to each card visual and filter the data accordingly:

Types of filters in Power BI reports - Power BI | Microsoft Learn

Hopefully, this provides what you are looking for.

Regards,

Tom

[Anonymous]

Hi TomMartens,

Thank you for your quick response, this was really helpful

Also, I would like to know that by using measures  can we make this happen

regards,

dsmitha

[TomMartens · Accepted solution]

Hey @Anonymous ,

sure, this can also be achieved by using measures.

You need three measures, that look like this ...

Measure Team 1 =
CALCULATE(
SUM( table[column] )
, table[teamcolumn] = "Team 1"
)

Hopefully, this provides what you are looking for!

Regards,

Tom

[Anonymous]

hi TomMartens,

Thank you for the solution

I need one more help, instead of Team 1 if am having 3 salesman name then how can i solve using a measure

regards,

dsmitha