Forum Discussion
True/False DAX query
Hi Anonymous
As long as your tables are all connected properly the mesaure should span across them with no problems.
Im assuming your tables follow the relationships below
Universities to StudentUniversities on the University column
StudentUniversities to Students on the Student column
If so, then a measure as below should work:
if(sum(Students[phd])>0,True(),False)
Place into a table the name column from the Universities table and the measure and you should have the result you requested :)
Hope this helps
Thanks,
George
Hi Anonymous
As long as your tables are all connected properly the mesaure should span across them with no problems.
Im assuming your tables follow the relationships below
Universities to StudentUniversities on the University column
StudentUniversities to Students on the Student column
If so, then a measure as below should work:
if(sum(Students[phd])>0,True(),False)
Place into a table the name column from the Universities table and the measure and you should have the result you requested :)
Hope this helps
Thanks,
George
Anonymous few question before post the solution:
in student univesity table, does each student can be only in one university or multiple university?
in student table, I assume each student is a unique row.
parry2k wrote:Anonymousfew question before post the solution:
in student univesity table, does each student can be only in one university or multiple university?
in student table, I assume each student is a unique row.
A student can only be part of one university.
And yes correct, each student is unique row