Forum Discussion
HASONEVALUE alternatives?
Label =
// Blank at aggregate level
if(HASONEVALUE('Table'[Code]),
LASTNONBLANK('Table'[Code],1),
BLANK()
)
Hi WestWinter
you can try like this,
turn off Row subtotals
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
WestWinter , can you shared the expected output example, Isfiltered or isinscope can help
example
if(isinscope ('Table'[Code]),
LASTNONBLANK('Table'[Code],1),
BLANK()
)amitchandak This is what I get using my original formula:
As you can see in my matrix, the row with only one value under it will replicate the value in the 2nd column. However, if there are 2 or more values under the row, it will not replicate the value in the 2nd column.
I had tried your formula, but everything is just blanked out in a non-filtered state.
WestWinter , Not clear with your example.
Can you share the expected output and data source (some sample data).
Seem like you need to check if the below level has only one row. In that can we need create a formula with allexcept
Have you tried an expression like this?
Label =
// Blank at aggregate level
if(ISINSCOPE('Table'[Code]),
LASTNONBLANK('Table'[Code],1),
BLANK()
)Pat
bump
Hi WestWinter
you can try like this,
turn off Row subtotals
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
