need HELP a formula to count

[jdelacrettaz]

Hi, I'm having a problem and I don't know how to solve it. I have a table with the invoices and each invoice is repeated x number of times depending on how many items it has. Create a table showing the number of kilos for each voucher and in Cantidad de Comprobantes (show how many vouchers are with the same number)

until here I come well, now I want to make a formula that gives me back the amount of vouchers that exceed 1000 kilos. the column reference is : cantidad de kilos > 1000

for example in this case I would have to return an amount of 8 vouchers that exceed 1000 kilos

here can download a sample pbix.  https://we.tl/t-9qXezjgP3S 

in this sample de count of rows that exceed 1000 kg are 23

[amitchandak · Accepted solution]

Please find the formula

Measure = CALCULATE(COUNTX(FILTER(VALUES(ventasxdia[numero y tipo]),[kg quantity]>=1000),[kg quantity]))

pbix -https://www.dropbox.com/s/b4w7u1ykucwmbrw/sample%20power%20bi.pbix?dl=0

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[parry2k]

@jdelacrettaz in your sample dataset i'm getting 23, is this what you are expecting the result to be?

[jdelacrettaz]

@parry2k yes, what formula did you do?