Forum Discussion
Solved
DAX expression question
Hi everyone, I'm looking for a DAX forumla that will return the column below "Significant Line". If a line contains at least one significant segment (Significant Segment = Yes), then each entry ...
Update like this:
Column =VAR _line = TableName[Line]VAR SigSeg =CALCULATE(MAX(TableName[Significant Segment]),TableName[Line] = _line,ALL())RETURNIF(SigSeg="Yes", "Yes", "No")tried and it worked like this:
hi apelleti
For calculated column, try like:
Significant Line =
VAR _line = [Line]
VAR SigSeg =
CALCULATE(
MAX([Significant Segment]),
[Line] = _line
)
RETURN
IF(SigSeg="Yes", "Yes", "No")
Update like this:
Column =
VAR _line = TableName[Line]
VAR SigSeg =
CALCULATE(
MAX(TableName[Significant Segment]),
TableName[Line] = _line,
ALL()
)
RETURN
IF(SigSeg="Yes", "Yes", "No")
tried and it worked like this:
hi apelleti
it works because Y is after N alphabetically.
this shall also work:
Column2 =
VAR _line = TableName[Line]
VAR SigSeg =
MAXX(
FILTER(TableName, TableName[Line] = _line)
TableName[Significant Segment])
)
RETURN
IF(SigSeg="Yes", "Yes", "No")
