Forum Discussion
Count rows
Hi. Tell me please.
How to calculate the "Count" column?
This column counts for each product the number of rows whose Value is greater than the current productProductName | Growth | Count |
product1 | 40.73 | 3 |
product2 | 11.53 | 6 |
product3 | 120.12 | 1 |
product4 | 150.21 | 0 |
product5 | -12,00 | 9 |
product6 | 5.12 | 8 |
product7 | 15.10 | 6 |
product8 | 20.20 | 5 |
product9 | 50.01 | 2 |
product10 | 40.02 | 4 |
I calculate this table like this:var competition_growth_percent = addcolumns(values(products[product_name]),"Growth",[Growth_percent_products]*100)
1 Reply
yuriy_lozinskiy , Create a new column like
new column =
var _1 = [Growth]
return
countx(filter(Table,[Growth] >_1),[ProductName])
