adding value to a matrix that only applies to one row

[iruserwin]

hi smart bi folks.

i have  a matrix with 5 rows.  I have one Value field that really only applies to the last row.  I know i can make it show the first or last value, but since there are mutliple values i think i would rather show blanks on roll up.  that is only show the field at the last row.

is that possible?

Here i have the field set to last (even tho its not pulling last - alphabetization of the accounting results field?)

[Fowmy]

@iruserwin 

Please provide a clear explanation of your problem and the expected results. 

[iruserwin]

apologies that i appear to not be clear.

in the screenshot provided the text on the far right comes from a notes field.  It really only applies to the record level.  I dont want to use last or first and have it roll up to the + rows Integration Completed Accounting Results.  

Is there a way to make the summary lines of the matrixc be blank instead of the last / first value?

[Anonymous]

Hi @iruserwin ,

You can refer the follow links to get it by using ISINSCOPE() function:

ISINSCOPE: The Key to Dynamic Data Drilldowns

Use IsInScope to get the right hierarchy level in DAX

Removing Blanks from Organizational Ragged Hierarchy in Power BI Matrix Visual - RADACAD

If the above one can't help you figure out, please provide some sample data(exclude sensitive data) with Text format and matrix fields settings? It would be helpful to find out the solution. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

And it is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards