Forum Discussion

tonylitvak's avatar
tonylitvak
New Member
8 years ago
Solved

Calculated Column based on filtered values of inside table

Hello everyone and thank you for your help in advance.  This is my first post in this forum!   I am trying to auto-calculate a new column called SuperCode.  For this example, i've specified wwhat t...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi tonylitvak

    Add this calculated Column

    SuperCode =
IF (
    CALCULATE (
        COUNT ( Table1[FileName] ),
        FILTER (
            ALL ( Table1 ),
            Table1[FileName] = EARLIER ( Table1[FileName] )
                && Table1[Status] = "Success"
        )
    )
        > 0,
    "Success",
    "Failed"
)
tonylitvak's avatar
tonylitvak
New Member
8 years ago

Marcel, thank you very much.  Im trying to keep this in the same table and looking for a DAX calculated column/measure.

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi tonylitvak

Add this calculated Column

SuperCode =
IF (
    CALCULATE (
        COUNT ( Table1[FileName] ),
        FILTER (
            ALL ( Table1 ),
            Table1[FileName] = EARLIER ( Table1[FileName] )
                && Table1[Status] = "Success"
        )
    )
        > 0,
    "Success",
    "Failed"
)
  • tonylitvak's avatar
    tonylitvak
    New Member
    8 years ago

    Zubair, thank you for the excellent response.  It works!  I'll try to make sense of the functions which is taking me a bit.