Forum Discussion
Connecting 3+ tables
Anonymous try following and tweak it from there :
Add two column in your main project table to define which project exists in which table
Project Exists in PS = VAR x = RELATED( PS[ProjectID] ) RETURN IF( x = BLANK(), 0, 1 ) Project Exists in PW = VAR x = RELATED(PW[ProjectID] ) RETURN IF( x = BLANK(), 0, 1 )
and then add a table using following DAX, it will put all projects together alongwith whcih category they are in
Total Projects = UNION( ADDCOLUMNS( Project, "Category", "Doesn't exists" ), ADDCOLUMNS( CALCULATETABLE( Project, FILTER( Project, Project[Project Exists in PS] = 1 && Project[Project Exists in PW] = 1 ) ), "Category", "Exists in Both" ), ADDCOLUMNS( CALCULATETABLE( Project, FILTER( Project, Project[Project Exists in PW] = 1 ) ), "Category", "Exists in PW" ), ADDCOLUMNS( CALCULATETABLE( Project, FILTER( Project, Project[Project Exists in PS] = 1 ) ), "Category", "Exists in PS" ) )
drop pie chart visual, use category from this new project table "Total Project" and use "count of project id" as value. I think this will get your what you are looking for.
Main table is Project .. 2 tools tables Projectsite and PW connected to Projects table ..
Can I have a Pie chart showing total projects using ProjectSite, Pw, Projectsite and PW and none of those 2 ?
I managed to connect them with " Style " table . but still not able to get the result i want
Anonymous
Still not fully clear about your requirements.
Are you try to have pie chart based on
- name from PW and show total distinct projects
- name from PS and show total distinct projects
Is this correct?
trying to get something like this
can you send some sample data?
Also if a project is in PW and PS, so it will show in
- project using project sies
- project using pw
- project using project sites and pw
it will account at 3 places, correct?