Forum Discussion

apelleti's avatar
apelleti
Icon for Helper I rankHelper I
3 years ago
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 ...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    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:
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi apelleti 

you can also use

SignificantLine =
IF (
"Yes"
IN CALCULATETABLE (
VALUES ( 'Table'[SignificantSegment] ),
ALLEXCEPT ( 'Table', 'Table'[Line] )
),
"Yes",
"No"
)

 

or

 

SignificantLine =
IF (
COUNTROWS (
CALCULATETABLE (
VALUES ( 'Table'[SignificantSegment] ),
ALLEXCEPT ( 'Table', 'Table'[Line] )
)
) > 1,
"Yes",
"No"
)