DAX ALL Formula

[gauravnarchal]

How can I add "ALL formula" in the below measure so that it ignores all filters in the visual?

First Sales Date in Selected =

MAXX(

TOPN( 1,

SUMMARIZE(ARInvoices,ARInvoices[InvoiceDate],ARInvoices[ProfileNumber]),

CALCULATE( MIN(ARInvoices[InvoiceDate])), ASC ),

ARInvoices[InvoiceDate])

[v-juanli-msft · Accepted solution]

Hi @gauravnarchal 

Create measures

Measure =
MINX (
    TOPN (
        1,
        FILTER (
            ALL ( 'Table 2' ),
            'Table 2'[customer no] = MAX ( 'Table 2'[customer no] )
        ),
        CALCULATE ( MIN ( [invoice date] ) ), ASC
    ),
    [invoice date]
)

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@gauravnarchal - Perhaps:

First Sales Date in Selected =
MAXX(
TOPN( 1,
SUMMARIZE(ALL(ARInvoices),ARInvoices[InvoiceDate],ARInvoices[ProfileNumber]),
CALCULATE( MIN(ARInvoices[InvoiceDate])), ASC ),
ARInvoices[InvoiceDate])

[gauravnarchal]

@Greg_Deckler  - Thank you for your response.

I tried using this measure and now it had ignored the first invoice date of the customer.

I am creating a measure to get the first invoice date of the customer. The measure should also ignore the filter/visual.

Below is the table.

[Greg_Deckler]

@gauravnarchal - You might need to use ALLEXCEPT then.

[gauravnarchal]

@Greg_Deckler  Can you please advise how can I add ALLEXCEPT formula in the below measure?

First Sales Date in Selected =

MAXX(

TOPN( 1,

SUMMARIZE(ARInvoices,ARInvoices[InvoiceDate],ARInvoices[ProfileNumber]),

CALCULATE( MIN(ARInvoices[InvoiceDate])), ASC ),

ARInvoices[InvoiceDate])

Thanks 

[Greg_Deckler]

@gauravnarchal - Same place I suggested the ALL. Really hard to say specifically without testing it. 

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Also, you can check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882