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 Ragha...
- 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
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
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