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 don't want to use the "is not blank" filter on visual to remove it as it's used in multiple visuals.

 

 

 

 

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.

10 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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

  • NelsonY's avatar
    NelsonY
    Regular Visitor
    3 years ago

    Is there any suggestion how I can eliminate those null?

    • amitchandak's avatar
      amitchandak
      Super User
      3 years ago

      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

  • 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

      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 )
  • 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.

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

    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.