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.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 years ago

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's avatar
NelsonY
Regular Visitor
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.