Measure - Easiest way to access row context

[GJA]

Hi Everybody, 

I would like to know what is the best way to access a value of table with a measure (not a calculated column).

for sample : I display this lines :

A

A

B
B

B

C

C

I would like to create à measure which is able to calculate anything from from the value of the first column. I often use lastnonblank(['Column1'],1). For the row 1 it would give me "A". But is it the best way ? Which solution do you use ?

[fhill]

Take a look at the "...X" DAX commands for some of the most common commands (COUNTX / COUNTAX / SUMX / AVERAGEX).  These allow for more Row Based logic to be included in the command.  You can do some simular functions with the CALCUALTE(... command also adding Filters into  logic.  I hope this helps get you started...

[amitchandak · Accepted solution]

@GJA , or something like this

if(max(['Column1']) ="A", 1,0)