Forum Discussion
Selected Value dax Query
A measure doesn't create rows so you won't be able to have those tabular lists. If the calculated table on your end, doesnt give you the correct order, you can just create two extra columns to kind of select the should be column values.
Sort2 = IFERROR ( VALUE ( NewTable[Sort] ), VALUE ( NewTable[Carrier] ) ) Carrier2 = IF ( NewTable[Sort] = NewTable[Type], NewTable[Type], NewTable[Carrier] )
I think i am havign trouble using this concept to incorporate to my existing data model. Is it possible to use it as a measure instead?
A measure doesn't create rows so you won't be able to have those tabular lists. If the calculated table on your end, doesnt give you the correct order, you can just create two extra columns to kind of select the should be column values.
Sort2 =
IFERROR ( VALUE ( NewTable[Sort] ), VALUE ( NewTable[Carrier] ) )
Carrier2 =
IF (
NewTable[Sort] = NewTable[Type],
NewTable[Type],
NewTable[Carrier]
)
The problem is i am using this table as dim to be connected to a fact table. so the relationship is many to many.. and also only A has data when it is connected becasue in the fact table the type is only shown. not the corresponding column which is the carrier. For example :