Forum Discussion
Solved
ALLNOBLANKROW - 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
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.
- 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
