Forum Discussion

NelsonY's avatar
NelsonY
Regular Visitor
3 years ago
Solved

Mysterious empty row in Matrix/Table

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...
Need Help
  • NelsonY's avatar
    NelsonY
    3 years ago

    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's avatar
tamerj1
Community Champion
3 years ago

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's avatar
NelsonY
Regular Visitor
3 years ago

No. Still not working.