Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Everybody,
An easy question, how can I add count under a text column in a table?
Thanks so much¡
Solved! Go to 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.
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.
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
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |