Forum Discussion

Thennarasu_R's avatar
Thennarasu_R
Responsive Resident
3 years ago

How to work All Dax Function

Hi,

I explored All Function Did'n get exact thing.

basics i Known It working Ignore visual and outside visual filter this basics one  .

My things is we apply ALL Function  inside the filter I had take filter .  I unable to understand that

Anyone help this one functions.


Thanks,
Thennarasu R

Need Help

2 Replies

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    3 years ago

    Hi Thennarasu_R ,

     

    You can compare the difference between them with the following three formulas.
    Create a MEASURE summary directly, which will keep all the external filtering contexts (in this case the COLOR field)
    The all function will filter all external filtering contexts.
    With allexcept you can specify to keep the external filtering contexts (here the color field)

    No_filter = SUM(FactInternetSales[SalesAmount])
    All_filter = CALCULATE(sum(FactInternetSales[SalesAmount]),ALL(FactInternetSales))
    All_filter = CALCULATE(sum(FactInternetSales[SalesAmount]),ALL(FactInternetSales))

     

    For more details, you can read below blog:

    Using ALLEXCEPT versus ALL and VALUES - SQLBI


    Best Regards,
    Henry


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