Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi Team,
Please find the screenshot below, the visual used is matrix. Now I nee dto have count of all non zero values as mentioned in figure, Kindly help . Thsi can be another visual or part of same table.
Thanks
Swapnil
Solved! Go to Solution.
@Anonymous,
You may refer to the following measure.
Measure = IF ( HASONEVALUE ( Table1[Date] ), SUM ( Table1[Qty] ), COUNTROWS ( FILTER ( VALUES ( Table1[Date] ), CALCULATE ( SUM ( Table1[Qty] ) ) > 0 ) ) )
@Anonymous,
You may refer to the following measure.
Measure = IF ( HASONEVALUE ( Table1[Date] ), SUM ( Table1[Qty] ), COUNTROWS ( FILTER ( VALUES ( Table1[Date] ), CALCULATE ( SUM ( Table1[Qty] ) ) > 0 ) ) )
hello @Anonymous,
Try something like:
as a calculated column:
IF Statement = IF(Table2[Qty]<=0,BLANK(),1)
as a measure:
Count IFs = COUNT(Table2[IF Statement])
// SUM should work as well.
Proud to be a Super User!
But if I want to put same in same matrix as last column then how would I do it ?As If I put this in column it creates multiple columns with same value
Yeah, that's why it's in another visual per your statement where you said it can be in another visual.
Proud to be a Super User!
Can I have count in matrix as only last column?
any inputs ?
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.