Hi there,
Could the number of items in a slice be shown in the Display name of a view so that it shows the amount in the button on the Primary Views bar?
How could I do the expression to count the items on the slice?
In the image I show the desired effect
You may do so by having display name of the view โPedidosโ something like below
CONCATENATE(โPedidosโ,"(",COUNT(SELECT(Table Name[Key Column], Slice Filter Condition)),")")
Here โPedidosโ is your view name , โTable Nameโ is the name of the table on which your slice for โPedidosโ view is based and โSlice Filter Conditionโ is the same filter condition that you have for slice โPedidosโ. Ths same slice filter condition you may use in the SELECT () statement given above.
An example shown below
Great!! Thank you so much.
I thought Expressions that use columns could not be used, due to the notice that says:
โThis formula is not evaluated in the context of a row, so column values are not available.โ
And I didnโt think that a simple SELECT would work.
User | Count |
---|---|
38 | |
27 | |
23 | |
23 | |
13 |