ALLNOBLANKROW - Understanding

[kolturra]

Hi,

I am trying to understand new DAX ALLNOWBLANKROW but I don't know why i am not able to understand this DAX.

Can some please share the article or video with the sample.

Thanks,

K Raghavender Rao

[Greg_Deckler · Accepted solution]

The short form of this is that if you feed this the Parent table in a relationship with another table that has unmatched rows, this will filter out the automatic "blank" that gets created. You've seen it in slicers, right? Where you get that annoying "blank".

https://www.tutorialspoint.com/dax_functions/dax_allnoblankrow_function.htm

https://www.sqlbi.com/articles/managing-all-functions-in-dax-all-allselected-allnoblankrow-allexcept...

https://www.bing.com/videos/search?q=ALLNOBLANKROW+DAX&qpvt=ALLNOBLANKROW+DAX&FORM=VDRE

[Chthonian]

https://dax.guide/allnoblankrow/

Returns all the rows except blank row in a table, or all the values in a column, ignoring any filters that might have been applied.