Forum Discussion
DAX ALL Formula
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.
gauravnarchal - Perhaps:
First Sales Date in Selected =
MAXX(
TOPN( 1,
SUMMARIZE(ALL(ARInvoices),ARInvoices[InvoiceDate],ARInvoices[ProfileNumber]),
CALCULATE( MIN(ARInvoices[InvoiceDate])), ASC ),
ARInvoices[InvoiceDate])
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.
gauravnarchal - You might need to use ALLEXCEPT then.
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
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