Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Regular Visitor

Sum of 3 different table

Hi All,

I things to be solve. This is for our divion activity dashboard. The condition as as follow

1. We have 2 big division

2. Under each division, there are multiple department with department head

3. Under department, there are multiple team

4. When anyone join the activity, the will received 1 star. so they will get a start when joining any division activitiy. This will sum up the team start

5. If thier head of department get a start, each of the team within the particular deparment also will get a star. 

6. If the head of division get a star, all team within the division will get a star.


so it's kind of 3 layer start thet would revied. I have seperate 3 layer as follow



so how to sum up all these 3 table based on the condition given above



Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors