count under text column in a table

[Alex_ds]

Hello Everybody,

An easy question, how can I add count under a text column in a table? 

 Thanks so much¡

[v-frfei-msft]

Hi @Alex_ds ,

We can create a measure as below to work around.

Measure = 
VAR pro =
    MAX ( 'Table'[Product] )
RETURN
    IF ( ISFILTERED ( 'Table'[Product] ), pro, COUNT ( 'Table'[Product] ) )

For more details, please check the pbix as attached.

[Alex_ds]

Hi v-frfei-msft,

It works correctly, thanks so much¡

Anyway, it just works if column "Product" is in the Table. Is there any chance it works if column "Product" is not in the table?

Grettings,

Alex

[v-frfei-msft · Accepted solution]

Hi @Alex_ds ,

Maybe we can create an index column to work around instead of using the Product.

Index = CALCULATE(DISTINCTCOUNT('Table'[Product]),FILTER('Table','Table'[Product] <= EARLIER('Table'[Product])))

Then we can update the measure as below and work it out.

Measure = 
VAR pro =
    MAX ( 'Table'[Product] )
RETURN
    IF ( ISFILTERED ( 'Table'[Index] ), pro, COUNT ( 'Table'[Product] ) )

Pbix as attached.

[AilleryO]

Hi,

My first thought is make a measure :

Number Of Producto = COUNTA([Producto])

But to display it only on the bottom line of your table is another question, may be just two tables with superposition ?

Hope it helps

Olivier