Forum Discussion
kolturra
Helper IV
Helper IVALLNOBLANKROW - Understanding
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
- 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
2 Replies
- Chthonian
Helper III
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.
- Greg_Deckler
Community Champion
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
