Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
romovaro
Responsive Resident
Responsive Resident

Table - Create measure using column + $ value

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 NameUSDTypeAgeingScopeComments
Client 110794External   
Client 13083External   
Client 13083External   
Client 210243External   
Client 311950BoB   
Client 319838BoB   
Client 42724BoB   
Client 42862External   
Client 48040BoB   
Client 443647BoB   
Client 44186BoB   
Client 52724BoB   
Client 59039BoB   
Client 63004BoB   
Client 7264BoB   
Client 75498BoB   
Client 71787BoB   
Client 79622BoB   
Client 75773BoB   

 

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
 
 
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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] )

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@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] )

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.