Solved! Go to 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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi 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:
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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank you Miguel - That did the trick. Much appreciated.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
107 | |
74 | |
66 | |
49 | |
48 |
User | Count |
---|---|
168 | |
88 | |
78 | |
72 | |
67 |