CALCULATED COLUMN WITH REPLACED BLANKS

[Anonymous]

Hello friends,

I'm having a trouble with building a DAX Measure to get some values and displays them as row values on matrix. Unfortunately when i use calculate doesn't work, my matrix turns into a huge amount of rows that i dont want. There's any way to only replace blanks without making the matrix "bigger". The quantity column below shows the quantity of a material, the blank values are materials that currently we dont have in storage, we have two tables, one with a list of all material numbers and another with all materials in storage, the first column of this matrix is the material number. Can you guys help me? Thanks so much.

 

[Whitewater100]

Hi:

I wonder if you may have choosed "Show Items with No Data". When you rclick a field the message below appears?

[Anonymous]

In this case i'm using a matrix visual. The amount of rows is correct, i want to have those rows without quantity values, but i want to replace the blanks with some text, but the sollution i found on internet with if conditions associated with sum didnt work.