Count Measure

[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.

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

[parry2k]

@jdelacrettaz can you share sample pbix file to get you the solution. It is not very clear what are you measures etc.

[jdelacrettaz]

hi perry,  here you can download the sample pbix https://we.tl/t-XyF8V4mLov. I want to know a formula to count the amount of kg that exceeds 1000 kg. in this case the formula should show me that 23 exceeds 1000 kg.

[v-chuncz-msft · Accepted solution]

@jdelacrettaz 

You may refer to the measure below.

Measure =
COUNTROWS (
    FILTER ( VALUES ( ventasxdia[numero y tipo] ), [Cantidad de Kilos] > 1000 )
)