cancel
Showing results for
Did you mean:
Frequent Visitor

## Filter values ​​by company

Hello!

I'm having trouble solving the following problem: I need to create a filter and graph to demonstrate how much each company has transferred and received from each other. For example: company 1 transferred to the company 2 US \$ 4,000.00 and received the 3 US \$ 500.00.

Thank you.

1 ACCEPTED SOLUTION
Skilled Sharer

@pxg08680

@Gelain

My bad =oP applying Filter will solve the issue:

• Transferred = CALCULATE(SUM(Sheet6[Sales]),FILTER(Sheet6,Sheet6[Extract] = "Transferred"))

Regards

Abduvali

6 REPLIES 6
Skilled Sharer

Hi @Gelain,

Just create 2 new calculated measures:

1. Transferred = Calculate(SUM(YourTableName[Value]),YourTableName[Extract] = "Transferred")

And drop them into your table chart.

Let me know if its what you were looking for.

Regards

Abduvali

Resolver III

@Abduvali

According to your solution I see some extra data. Looking at this below image

Table1 is raw data. By applying your formula and making the data into a table,

The yellow marked Row seems to be an extra one becuase, take an example with ID Company 3::

ID Compnay 3 has

Receive 1000 which is row #4 GOOD.

Transfer of 1000 and 500 which are row #4 and row #6 GOOD.

But I don't understand the Row#5 which says Receive 1000 and transfer 1000 NOT GOOD.

Skilled Sharer

@pxg08680

@Gelain

My bad =oP applying Filter will solve the issue:

• Transferred = CALCULATE(SUM(Sheet6[Sales]),FILTER(Sheet6,Sheet6[Extract] = "Transferred"))

Regards

Abduvali

Resolver III

@Abduvali

Filter works.

@Gelaincan mark this as solution if this is what you were trying to do.

Frequent Visitor

Hello @pxg08680 and @Abduvali!

Thank you for helping me.

I was able to correctly generate the value sent and received by company. To finish, I need to create two filters: one for the company that transferred and another filter for the company that received the values, that is, to detail the destination of the resources transferred by company. I made a few attempts, but could not solve.

Skilled Sharer

Try this...

Announcements