How to reference 2 different values of same measures

[Anonymous]

Hi,

I have a Measure. Lets call it X

When I have X slected in a card visualization it equals 2

But when I have X (lets call it Xa) as a column in table it shows 1.3 for a specific row (lets call this row A). This varies depending on the row in the table. 4 others rows exist (B,C,D,E)

My objective: write a DAX statement IF X < Xa,b,c,d,e then THEN = TRUE, else = FALSE. 

After I should be to put this as an additional column in the table and have TRUE/FALSE values depending on the outcome of whether X < X(a,b,c,d,e)

I have wasted alot of time figitting around, so help is massively appreicated.

[jthomson]

Your precise desired outcome is unclear as to whether you want to return true if X is less than any of the subsets or one of the subsets, I'll assume any of them (but the logic would be reversed if it's all of them) - try something like:

newmeasure = 

var stepa = calculate([oldmeasure], the filter context when you've selected row a)

repeat this for each row

return if ([oldmeasure] < stepa, "true",if ([oldmeasure] < stepb, "true",if ([oldmeasure] < stepc, "true",if ([oldmeasure] < stepd, "true",if ([oldmeasure] < stepe, "true","false")))))