Add Count Value from a Slice to Custom Menu Name

[BobSig]

How can I add the Count Value from a Slice, to the appropriate Custom Sub Menu Name? As the user is looking at a sub-menu with five different selections, I want them to see the number of items associated with that selection.

I have a table named Homes.  This table contains information submitted by clients requesting work to be performed on their home.  Each application can have one of five different statuses.  They are, New, Being Reviewed, Needs Inspection, Inspector Assigned and Declined.  I have a slice for each status.  I have added five virtual columns to the main table Homes, to count each of these status types.  All of that is working, so I know how many homes are in each status and view.

My custom Menu has a sub menu with a listing for each of these status types.  When the user clicks on one of these selections, they see a card view of each home having the menu status.  Example: Menu Name is New Applications, when the user clicks this menu selection, they see only New home applications and their associated information.

What I would like to do is add the Count Value from each slice to the Menu name for a quick reference as to how many listings will be found under each menu type.  So, If I have five New Applications, I would like to see the Menu name of New Applications  5,  and if the Declined status has two I would like the Menu selection(Name) Applications Decline  2.

Hope this makes sense.

[TeeSee1]

Supposing your MENU table has a column STATUS corresponding to each submenu row, then you can try something like the following and show it as submenu.

"NEW HOME APPLICATIONS - " & COUNT(FILTER("HOMES", [STATUS]=[_THISROW].[STATUS])

[BobSig]

Thanks. I will give this a try. Where will I place the expression? Menu
items do not have places to place expressions, like App Formula or Valid
If, etc

[BobSig]

I have not been able to make this work.

Any other suggestions?

[TeeSee1]

How is your menu constructed? If one menu is one data row in a "MENU" table, you can add a VC to place the expression in.

[BobSig · Accepted solution]

Thanks for the reply. Yes, my menu table currently has 28 rows. I am
guessing, about eight of these will have a Menu Name with a Count
included. I have added a virtual column named, Count Name. I am currently
working on the expression. Here is a copy of my current expression. I am
not sure if there is a better way to write this, but, so far this seems to
be working. Once I have the expression complete, I will use this Count Name
column as my Menu Display Names. Any help/improvements on my expression
are welcome.

SWITCH(
[Display Name],
"New Home Applications", CONCATENATE("New Home Applications (",
COUNT(Homes with New Application[Row ID]), ")"),

"Applications Assigned for Review", CONCATENATE("Applications Assigned
for Review (", COUNT(New Application Being Reviewed[Row ID]), ")"),

"Home Applications Declined", CONCATENATE("Home Applications Declined (",
COUNT(Homes Application Declined[Row ID]), ")"),
[Display Name]
)

[BobSig]

I was able to accomplish this with the VC and Expression.  Hoping there is a better expression.