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
maheshwarineha
Frequent Visitor

find the project wrt teacher

I have 3 tables that are connected with relationships. I need to write a measure to find out Out of all the projects in the system, how many projects is a teacher registered. In percentages and numbers.

tables are  :

Project Project_Teacher Teacher
id name ProjectidTeacher id id name
1cw 14 1fer
4ve 27 5berw
6fwf 48 7gergw
8few 36 4erfgw
3fvw      
5vw      

 

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@maheshwarineha , Join second table with Project and  Teacher (1 - Many)

 

the have measure

divide(countrows(Project_Teacher), calculate(countrows(Projects), allselected() ) )

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@maheshwarineha , Join second table with Project and  Teacher (1 - Many)

 

the have measure

divide(countrows(Project_Teacher), calculate(countrows(Projects), allselected() ) )

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.