Forum Discussion

WestWinter's avatar
WestWinter
Icon for Helper II rankHelper II
5 years ago
Solved

HASONEVALUE alternatives?

So I currently have this formula that works well to show a blank value at an aggregate level, while showing up correctly at a row level. However, I noticed that if the aggregate level only has one va...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    5 years ago

    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.

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Have you tried an expression like this?

 

Label =

// Blank at aggregate level
if(ISINSCOPE('Table'[Code]),
LASTNONBLANK('Table'[Code],1),
BLANK()
)

 

Pat