Forum Discussion

seabassk's avatar
seabassk
Regular Visitor
9 years ago
Solved

Ambiguity in relationships due to zero values and empty strings

Hey everyone,   I've been reading a lot of reading in here and a lot of the tips and solutions posted here were very helpful for me in creating some solutions in Power BI, so thank you for that :)....
Need Help
  • MFelix's avatar
    MFelix
    9 years ago

    Hi seabassk,

     

    On the advance query filter out the zero / empty values on the column you are refering and this will filter the information from your Data, so giving the 1st option in your post.

     

    Regards,

    MFelix

  • seabassk's avatar
    seabassk
    9 years ago

    Thank you MFelix, this worked nicely so far. I used the filter option of the column in the query editor. This gave me the follwing code:

     

    = Table.SelectRows(#"Changed Type3", each ([#"Order-ID"] <> null and [#"Order-ID"] <> ""))

    This should, in the future when new rows are added with new "Order-IDs" display and include these Order IDs and the repsective Rows, of course unless they are null or "", right?

seabassk's avatar
seabassk
Regular Visitor
9 years ago

Thank you MFelix, this worked nicely so far. I used the filter option of the column in the query editor. This gave me the follwing code:

 

= Table.SelectRows(#"Changed Type3", each ([#"Order-ID"] <> null and [#"Order-ID"] <> ""))

This should, in the future when new rows are added with new "Order-IDs" display and include these Order IDs and the repsective Rows, of course unless they are null or "", right?

MFelix's avatar
MFelix
Icon for Super User rankSuper User
9 years ago

Hi seabassk,

 

This will work in the future also when new rows are added because in the query view you are saving a number of steps that are repeated in a certain order when you update your data source, so when you add the new rows this will continue to remove the null or blanks, it's like a macro.

 

Regards,

MFelix

  • seabassk's avatar
    seabassk
    Regular Visitor
    9 years ago

    Thank you MFelix!