Forum Discussion
Solved
DAX Measure
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 ...
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
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
