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
chris_jones
New Member

Counting text values that are with a linked table

Hi

 

I have two tables which are linked.

 

I am trying to ascertain count from one table (The Main Data) to a reference table containing 12 codes)

 

This code bring back the count of the codes with "FC" in it but i need to reference the table containing the list of 12

 

CountDispositions =
CALCULATE ( COUNTROWS ( 'DataTable' ), 'DataTable'[Code] = "FC" )
 
Any help in amending the formaule to accomondate.
 
Thank you
 
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@chris_jones ,not very clear

 

you can data from the one table to another

minx(filter(table1, table1[user] =table2[user]), table1[projenddate_date])

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@chris_jones ,not very clear

 

you can data from the one table to another

minx(filter(table1, table1[user] =table2[user]), table1[projenddate_date])

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.