Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Use ALLNOBLANKROW in a filter?

I have two tables 

 

Data Table

 

CountryCityPopulation
AX5
BY10
CZ15
DQ20
EP25
AR6
BS7
CT8
AU9
BV16
DW10
EK2

Filter Table

 

Country_Filter
A
C
E

 

 
 
Those two tables have many to one relationship based on Country and Country_Filter.
 
This is my measure: CALCULATE(SUM(Data Table[Population]),ALLNOBLANKROW(Filter Table)))
 
The measure above returned what I want... but I am wondering how ALLNOBLANKROW works here.
 
 
Because when I use ALL instead of ALLNOBLANKROW, the result changes.
 
Thank you in advance!
 
 
 
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Both ALL and ALLNOBLANKROW works similary with minor difference. Both functions ignore any applied filters. 

     

    ALL returns ALL records , after ignoring the filters (including external to the visual.)

    ALLNOBLANKROW returns all non-blank records , after ignoring the filters(.including external to the visual.)

     

    Thanks
    Raj

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Both ALL and ALLNOBLANKROW works similary with minor difference. Both functions ignore any applied filters. 

     

    ALL returns ALL records , after ignoring the filters (including external to the visual.)

    ALLNOBLANKROW returns all non-blank records , after ignoring the filters(.including external to the visual.)

     

    Thanks
    Raj

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi,@rlee1982

    ALL : Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied. This function is useful for clearing filters and creating calculations on all the rows in a table.

    ALLNOBLANKROW: From the parent table of a relationship, returns all rows but the blank row, or all distinct values of a column but the blank row, and disregards any context filters that might exist.

    You can also refer to the following links:

    ALL function (DAX) - DAX | Microsoft Docs

    ALLNOBLANKROW function (DAX) - DAX | Microsoft Docs

    Best Regards,

    Charlotte Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.