Table - Create measure using column + $ value

[romovaro]

Hello,

Quick question. I have a table with different columns. I have one that shows USD value and another one Type (can be External or BoB)

I want to create 2 measure in the table below that shows per row the:

- Amount $ USD External

- Amount $ USD Bob 

Client Name	USD	Type	Ageing	Scope	Comments
Client 1	10794	External
Client 1	3083	External
Client 1	3083	External
Client 2	10243	External
Client 3	11950	BoB
Client 3	19838	BoB
Client 4	2724	BoB
Client 4	2862	External
Client 4	8040	BoB
Client 4	43647	BoB
Client 4	4186	BoB
Client 5	2724	BoB
Client 5	9039	BoB
Client 6	3004	BoB
Client 7	264	BoB
Client 7	5498	BoB
Client 7	1787	BoB
Client 7	9622	BoB
Client 7	5773	BoB

I already have the counts of BOB and External but I want to link the counts with $.

Count BoB-Type = COUNTROWS(Filter('Tablet', SEARCH("BoB", 'Table'[Type], , 0)>0))

Count External-Type = COUNTROWS(Filter('Table', SEARCH("External", 'Table'[Type], , 0)>0))

Thanks,

Robert

[amitchandak · Accepted solution]

@romovaro , example like

SUMX(Filter('Tablet', SEARCH("BoB", 'Table'[Type], , 0)>0), [USD])

or

SUMX(Filter('Tablet', 'Table'[Type]  = "BoB" ), [USD])

Count External-Type = SUMX(Filter('Table', SEARCH("External", 'Table'[Type], , 0)>0), [USD] )