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
ivancornejo_'s avatar
ivancornejo_
Frequent Visitor
8 years ago

SteveCampbell Yes

Result: 

Total in a single "Contador" show incorrect values,  but in the last "Contador" that is correct, but the total show 1, and it is incorrect  D: 

 

I'll tried send the pbix file

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi ivancornejo_,

Where is your .pbix file? Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. More people will benefit from here.

Best Regards,
Angelia

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi 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