Forum Discussion

juan_pablo's avatar
juan_pablo
Helper V
6 years ago
Solved

Simple ALL function not working

Hi, I really don't get why this simple measure is not working on this simple one table model: The measure should ignore the filter on commercialInvoiceNo nevertheless when I apply a filter on comme...
all
DAX
DAX Calculation
ONE TABLE MODEL
REMOVEFILTERS
  • JarroVGIT's avatar
    JarroVGIT
    6 years ago

    Hi juan_pablo ,

    Well, the main reason I am active in this community is because I learn from every answer I give 🙂 This question is no exception, I really had to look into the behaviour of this feature in PBI. 

    As it turns out (and I didn't know this), you cannot escape filters that are set on the Filter pane. Apparently, there is this mechanic called Auto Exist. Here is an article that explains in detail how the result gets to what it is:

    https://www.sqlbi.com/articles/understanding-dax-auto-exist/ 

    Hope this helps you out, let me know if you have any more questions 🙂

     

    Kind regards

    Djerro123

    -------------------------------

    If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

    Keep those thumbs up coming! 🙂

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi JarroVGIT ,

 

Great find, thanks. This question had me puzzled too.  

juan_pablo  I tried to translate it to your PBIX,  and as far as I can see it the only way the get the desired result is when you create a new table with all distinct commercial invoice numbers, link it to the data table (single direction) and use the new table in the visual filter.  

 

Jan