Forum Discussion
Resolver IIIDAX : Based on condition on multi column
seems you are trying to write a measure, try like:
Column =
VAR _table =
FILTER(
ALLSELECTED(data),
data[Column1]=MAX(data[Column1])
)
VAR _check1 = COUNTROWS(_table) > 1
VAR _check2 =
COUNTX(
_table,
IF(CONTAINSSTRING(data[Column2], "de"), 1)
) > 0
VAR _result = IF(_check1 && _check2, 1, 0)
RETURN _result
Resolver IIIHello,
If Number continuous and if it contains De then only DAX should get 1 else 0.
Hope this clear now.
For Ex: S1 - We have two occurrence and also we have De in it. So formula should get 1.
S2 - We have two occurrence but we do not have De in it so formula should get 0
Regards,
Chandrashekar B
Super Userhi Chandrashekar ,
Not sure if i really get you, you may try the following:
Column =
VAR _table =
FILTER(
data,
data[Column1]=EARLIER(data[Column1])
)
VAR _check1 = COUNTROWS(_table) > 1
VAR _check2 =
COUNTX(
_table,
IF(CONTAINSSTRING(data[Column2], "de"), 1)
) > 0
VAR _result = IF(_check1 && _check2, 1, 0)
RETURN _result
it works like:
- Chandrashekar
Hello,
Thank you for your reply. am getting below error.
Regards,
Chandrashekar B
- FreemanZ
seems you are trying to write a measure, try like:
Column =
VAR _table =
FILTER(
ALLSELECTED(data),
data[Column1]=MAX(data[Column1])
)
VAR _check1 = COUNTROWS(_table) > 1
VAR _check2 =
COUNTX(
_table,
IF(CONTAINSSTRING(data[Column2], "de"), 1)
) > 0
VAR _result = IF(_check1 && _check2, 1, 0)
RETURN _result
- Chandrashekar
Thank you. It is working fine.
Regards,
Chandrashekar B