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
Memorable Member
8 years ago

Did you try changing 

Contador :=   
	if(
		COUNTROWS('Article')*COUNTROWS(Size)-COUNTROWS('Stock Price')<1,
			0,
			COUNTROWS('Article')*COUNTROWS(Size)-COUNTROWS('Stock Price')
		)

What was the result? If you could send a the pbix file that would help a lot, depending on the data

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