Forum Discussion
Solved
Matrix Table configuration problem
Hi All, Having a problem getting a matrix table structured the way I want it. I need to combine data from two tables into something like the embedded pic. The matrix table is structured so the Progr...
Hi Clint ,
Try to make the following change, however without any data is difficult to pin point the correct syntax
Project Desc in Scope = SWITCH ( TRUE (), ISINSCOPE ( 'Exceptions Reporting'[Description] ), BLANK (), ISINSCOPE ( 'Projects'[Project Name] ), MAX ( 'Projects'[Project Description] ) )
Hi Miguel,
The image I attached is a mock-up of what the report should look like. Here is the measure I tried to use to get the Program related data to show only at the Program level:
Project Desc in Scope =
CALCULATE (
IF(ISINSCOPE('Projects'[Project Name]),
MAX('Projects'[Project Description]),
IF(ISINSCOPE('Projects'[Project Name]) && IF(ISINSCOPE('Exceptions Reporting'[Description]),""),"")))
Unfortunately, this doesn't work.
I think I understand why it doesn't work but I don't know how to write the dax to make it work correctly
Hi Clint ,
Try to make the following change, however without any data is difficult to pin point the correct syntax
Project Desc in Scope =
SWITCH (
TRUE (),
ISINSCOPE ( 'Exceptions Reporting'[Description] ), BLANK (),
ISINSCOPE ( 'Projects'[Project Name] ), MAX ( 'Projects'[Project Description] )
)
Thank you Miguel - That did the trick. Much appreciated.