Forum Discussion
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 ...
Oh, sorry
I was very busy last week.
here is the .pbix file:
https://drive.google.com/file/d/1PLzB6IflxMZR8128BV_M31BAQ0Q4JN7d/view?usp=sharing
and still I can't resolve this :/
thanks.
v-huizhn-msft
Microsoft Employee
Microsoft EmployeeHi ivancornejo_,
Based on my understanding, the first visual is right. For second visual, what result you want to get, how about using the formula below?
Contador = SUMX('Daily Stock',if( COUNTROWS('Article')*COUNTROWS(Size)-COUNTROWS('Daily Stock')<1, 0, COUNTROWS('Article')*COUNTROWS(Size)-COUNTROWS('Daily Stock') ) )
Best Regards,
Angelia