Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    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 )
    )
)
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

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 )
    )
)