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 product
ProductName | 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)
@yuriy_lozinskiy , Create a new column like
new column =
var _1 = [Growth]
return
countx(filter(Table,[Growth] >_1),[ProductName])