Forum Discussion
Need count for matrix non zero values
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...
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 ) ) )
Yeah, that's why it's in another visual per your statement where you said it can be in another visual.
Can I have count in matrix as only last column?
any inputs ?