Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Is there a function that could help me CountRows that not equals 0.
I've got somethig like this but !=0 doesn't work.
Zajete = CALCULATE(
COUNTROWS(Main),
FILTER(VALUES(Main[MasaNetto]),Main[MasaNetto] != 0))
Or can I SUM rows minus my measure that count empty rows.
Wolne = CALCULATE (
COUNTROWS ( Main ),
FILTER ( VALUES ( Main[MasaNetto]), Main[MasaNetto]=0))
Solved! Go to Solution.
Measure =
CALCULATE (
COUNTROWS ( FILTER ( VALUES ( Main[MasaNetto] ), Main[MasaNetto] <> 0 ) )
)
Measure =
CALCULATE (
COUNTROWS ( FILTER ( VALUES ( Main[MasaNetto] ), Main[MasaNetto] <> 0 ) )
)
@PiotrBZMZ , If MasaNetto is a column try like
Zajete = CALCULATE(
COUNTROWS(Main),
FILTER(main,Main[MasaNetto] != 0 && not(isblank(Main[MasaNetto])) ))
if, MasaNetto is a measure, then you need some grouping to filter this
Zajete = CALCULATE(
COUNTROWS(Main),
FILTER(VALUES(Main[Group Column]),Main[MasaNetto] != 0))
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.