Add only the first row of each Order

[Anonymous]

Hi all !

I have the following table:

ID	Order Number	Value
1	1	2
2	1	2
3	1	2
4	2	1
5	2	1
6	3	4
7	3	4
8	4	6
9	4	6
10	4	6

And I need to get these results for every order number:

Order Number	Value
1	2
2	1
3	4
4	6

Is it possible to make a measure in DAX that only takes into account the first value of each order number?

Thanks!

Regards!

[Ashish_Mathur]

Hi,

Drag Order to the Table visual and write this measure

=min(Data[NumberValue])

[v-eachen-msft]

Hi @Anonymous ,

You could create a table with the following DAX:

New Table =
DISTINCT (
    SELECTCOLUMNS ( 'Table', "Order Number", 'Table'[Order Number], "Value", 'Table'[Value] )
)

[harshnathani]

Hi @Anonymous ,

Measure = SUMX(SUMMARIZE('Table','Table'[Order Number],'Table'[Value]),'Table'[Value])

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

Hi @Ashish_Mathur @Ashish_Mathur  @v-eachen-msft @AlB @az38  !!

Here's how I solved it:

Total =
SUMX (
ADDCOLUMNS (
SUMMARIZE ( Fact_Table, Fact_Table[ID] ),
"@Valor", CALCULATE(MAX ( Fact_Table[Value] ))
),
[@Valor]
)

Thanks for your help!

[AlB]

Hi @Anonymous 

1.Place Table1[Order] in a table visual

2. Place this measure in the visual

Measure =
VAR firstID_ =
    MIN ( Table1[ID] )
RETURN
    CALCULATE ( DISTINCT ( Table1[Number Value] ), Table1[ID] = firstID_ )

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[az38]

@Anonymous 

you can do it in visual setings, if you will set Value field aggregation as First, Minimum, Average or Maximum, doesn't matter