topic Re: DAX Measure in DAX Commands and Tips

DAX Measure

aghonaim — Sat, 24 Oct 2020 07:48:13 GMT

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

Re: DAX Measure

AlB — Sat, 24 Oct 2020 08:34:48 GMT

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

Re: DAX Measure

aghonaim — Mon, 26 Oct 2020 04:14:02 GMT

It works perfectly fine, thanks AlB !