DAX Measure

[aghonaim]

Can someone help me with the most optimzed DAX measure formula to get the Value associated with the max Trans# for each File ?

File	Trans#	Value
A	1	5
A	2	6
B	1	3
B	2	1
B	3	2
C	1	3
C	2	2
C	3	1
C	4	3

to make the result be:

A		6
B		2
C		3
Total		11

[AlB · Accepted solution]

Hi @aghonaim 

1. Place Table1[File] in a table visual

2. Create this measure and place it in the visual

Measure =
VAR auxT_ =
    FILTER (
        Table1,
        Table1[Trans#] = CALCULATE ( MAX ( Table1[Trans#] ), ALLEXCEPT ( Table1, Table1[File] ) )
    )
RETURN
    SUMX ( auxT_, [Value] )

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

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

Cheers 

[aghonaim]

It works perfectly fine, thanks @AlB !