Forum Discussion

Clint's avatar
Clint
Icon for Helper V rankHelper V
3 years ago
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...
Need Help
  • MFelix's avatar
    MFelix
    3 years ago

    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] )
)

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
3 years ago

Hi Clint ,

 

Based on what you refer you may need a ISINSCOPE has you refered however this needs to be calculated in the correct way since if you do a isinscope for the program name that is the parent that will return values in all lines.

 

Another option can be the HASONEVALUE for the exception.

 

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.

Clint's avatar
Clint
Icon for Helper V rankHelper V
3 years ago

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
  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    3 years ago

    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] )
)

     

    • Clint's avatar
      Clint
      Icon for Helper V rankHelper V
      3 years ago

      Thank you Miguel - That did the trick.  Much appreciated.