Forum Discussion
Chandrashekar
Resolver III
Resolver IIIDAX : Based on condition on multi column
Hello, Sorry it is refering to the below post Link: Solved: Column Formula : Based on condition - Microsoft Fabric Community Hello, Need help in DAX for below table. I am looking for form...
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
ChandrashekarResolver III
Resolver IIIHello,
Thank you for your reply. am getting below error.
Regards,
Chandrashekar B
FreemanZ
Super User
Super Userseems 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