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

Thanks Vvelarde

I follow your step and I get this,

 But when I change 

AllSizes = COUNTROWS(ALLSELECTED(Table1[Size]))   --> AllSizes = COUNTROWS(ALLSELECTED(Size[size]))

Matrix show this,

 

As you can see, Total for (NoSizeAvailable-Total) is correct, I have 8 Articles in Blank , but the others numbers are incorrect 

and the same with the others measures :/ 

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