Forum Discussion

ivancornejo_'s avatar
ivancornejo_
Frequent Visitor
8 years ago

Count blank in matrix

Hi, I have this matrix ->     I need count the blank spaces in a new column or use a measure. I tried a lot of possibles solutions from the forum, but a can't get a solution  Help, please   ...
Need Help
SteveCampbell's avatar
SteveCampbell
Icon for Memorable Member rankMemorable Member
8 years ago

You can use a measure:

 

 

Blank Count =
CALCULATE(COUNTBLANK(Daily Stock[Units])
                    ,ALL(Daily Stock[Size])

)

 

 

This will count all blanks in all sizes

  • ivancornejo_'s avatar
    ivancornejo_
    Frequent Visitor
    8 years ago

    Thanks SteveCampbell,

     

    But when I use your formula, I get this,

     

    • SteveCampbell's avatar
      SteveCampbell
      Icon for Memorable Member rankMemorable Member
      8 years ago

      I am wondering if your values are truely blank. What do blank values appear as in the table?

      Can you try the measure:

      Contador := 
CALCULATE(
	COUNTROWS('Daily Stock')
	,NOT('Daily Stock'[Units]>0)
	,ALL('Daily Stock'[Size]))

       

      • ivancornejo_'s avatar
        ivancornejo_
        Frequent Visitor
        8 years ago

        Thanks again, SteveCampbell, but I still get the same result with this other formula 

         

        The values in blank show an article without units for a size.