Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
125 | |
78 | |
76 | |
59 | |
51 |
User | Count |
---|---|
166 | |
84 | |
68 | |
67 | |
57 |