Mysterious empty row in Matrix/Table

[NelsonY]

My visual is working fine with referencing the measure directly.

It produce a blank line when I branching from it.  I need help to get rid of the blank line from the branched measure.  I don't want to use the "is not blank" filter on visual to remove it as it's used in multiple visuals.

[v-yalanwu-msft]

Hi, @NelsonY ;

Very happy to hear that your problem has been solved, can you kindly mark the reply as a solution to close the case?

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @NelsonY ;

I create a simple file,

Vs

and if i change the measure.

Measure = 
var _value=SUM(financials[Sales])
return IF(_value>0,"True",IF(_value<>BLANK(),"False"))

The final show：

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[NelsonY · Accepted solution]

Hi yalanwu,

Thanks for your advise.  It doesn't help.  However, I sort of finding the issue.  The blank line disappeared after I remove all fields from the visual and putting them back.  This could be a bug or some corruption with my pbix file.

[tamerj1]

Hi @NelsonY 
The engine creates this line automatically to resolve the measure's blank value even if it does not actually exist. The reason is that the comparison operator forces all values including BLANK similar to adding 0 for example. You may try

t1 =
VAR CurrentValue = [Last 70 Avg Max Host Cpu Usage]
RETURN
    IF ( NOT ISBLANK ( CurrentValue ), CurrentValue > 0.5 )

[NelsonY]

No. Still not working.

[NelsonY]

The result is the same.  I'm not convince it's dimension data issue.  If you look at my first screenshot, the hostname is in accending order and there's no null value with the measure.  Why should I getting null when I ust doing a comparsion against a constant value?

[tamerj1]

Hi @NelsonY 
It is not a dimension data issue. I didn't say that. If my solution did not work please try 

t1 =
IF ( NOT ISEMPTY ( 'Table' ), [Last 70 Avg Max Host Cpu Usage] > 0.5 )

[NelsonY]

Is there any suggestion how I can eliminate those null?

[amitchandak]

@NelsonY , If Dimension does not have all values, try to fix the Dimension.

You can use visual level of page level filter and remove blank values

[amitchandak]

@NelsonY , The empty row can come,  In case you have fact and dimension use in visual.

When the dimension is missing values that are there in fact. Or fact has null in the join column