Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I want to count all numbers in a column that are the number 10
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
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
@ligalbert ,Hope you need row count
A new measure =
Countrows(filter(Table, Table[Late Fee] =10))
User | Count |
---|---|
98 | |
90 | |
78 | |
71 | |
64 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |