Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Clint
Helper V
Helper V

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 Program name (projects table) is the 1st level of the hierarchy and each exception (exceptions table). What I want is, program related data only at the program level and exception data only at the exception level.
I tried using in scope to do this for the Program - starting w/program description but it didn't work and repeated the field values for each exception. Would appreciate some insights into how to isolate Program data so it only shows on the top line.
Ex. mockup
matrix table problem.jpg

 

1 ACCEPTED SOLUTION

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

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

4 REPLIES 4
MFelix
Super User
Super User

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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



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

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.