How to Count and filter in Power bi to create a measure

[ligalbert]

I want to count all numbers in a column that are the number 10 

 

[v-yangliu-msft]

Hi  @ligalbert ,

1. Create measure.

Measure =
CALCULATE(COUNT('Table'[Late Fees]),FILTER(ALL('Table'),'Table'[Late Fees]=10))

Measure 2 =
COUNTX(FILTER(ALL('Table'),'Table'[Late Fees]=10),[Late Fees])

2. Result:

If you need pbix, please click here.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[jcalheir]

Hi you can create a measure that uses CountRows with a filtered table.

COUNTROWS(
    FILTER( YourTable, Late Fees = 10 )

)

For further information and other examples check out this article:

https://www.goodly.co.in/countif-power-bi-dax/

Hope it helps

[amitchandak]

@ligalbert ,Hope you need row count

A new measure  =

Countrows(filter(Table, Table[Late Fee] =10))