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.

NelsonY's avatar
NelsonY
Regular Visitor
3 years ago

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

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 )