Countif = > 500

[pocquet]

Hello,

I am struggling to get a countif style formula working in power bi.

Basically, I have a list of around 400k rows and want to pull out as a count only rows that value is less than or equal to 500

Thanks

Jon

 

[MarcelBeug]

The query below creates a table with 1 column with 400,000 rows of random numbers between 475 and 525 and counts the umber of row >= 500:

let
    Source = Table.TransformColumns(Table.FromList(List.Random(400000),each {_},type table[Value = number]),{"Value", each Number.Round(475+50*_,0), Int64.Type}),
    CountGE500 = Table.RowCount(Table.SelectRows(Source, each [Value] >= 500))
in
    CountGE500

 

[Matt Allington]

I would do it in dax as a measure like this

myCount = calculate(countrows(table),table[value]>=500)