topic Re: CALCULATED COLUMN WITH REPLACED BLANKS in DAX Commands and Tips

CALCULATED COLUMN WITH REPLACED BLANKS

Anonymous — Fri, 13 May 2022 20:31:32 GMT

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.

Re: CALCULATED COLUMN WITH REPLACED BLANKS

Whitewater100 — Fri, 13 May 2022 21:08:16 GMT

Hi:

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

Re: CALCULATED COLUMN WITH REPLACED BLANKS

Anonymous — Sat, 14 May 2022 02:08:05 GMT

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.