Forum Discussion

Amberr567's avatar
Amberr567
Frequent Visitor
2 years ago
Solved

Adding additional information to a matrix

Hello   I am looking to add additional fields to a matrix, but I am not seeing a solution within power bi.   The user would like to be able to see a summarization field, essentially, that will gi...
Need Help
  • Amberr567's avatar
    Amberr567
    2 years ago

    I ended up working around this with SQL for my data source. 

     

    Case
    when EXISTS(select 1 from CourseCompletion b where b.student= a.student and b.course like '%coursename%') then '1'
    else '0'
    end as 'Course1'

Alex87's avatar
Alex87
Solution Sage
2 years ago

Hello,

It will not work if you build the matrix as described, but if you use the name on rows and than add individual measures in values you could add as many additional fields as you want.

  • Amberr567's avatar
    Amberr567
    Frequent Visitor
    2 years ago

    Is there a way to make the new addition to values only appear at the right side of the matrix? I can only really successfully get something that looks like the below table. The "Training Complete" field is basically going to be the same for every course, as it would signify that all the courses are complete, so having it under every course would be redundant.

    Namecourse 1course 1course 2course 2
     StatusTraining complete? StatusTraining Complete?