Forum Discussion

POSPOS's avatar
POSPOS
Icon for Post Partisan rankPost Partisan
1 year ago
Solved

Create calculated column with measure conditions using DAX

Hi all, I have a sample data as below Sample file is attaced here. I have created three measures, to highlight the employees who has only "FY 24"and only "FY 25" values. Measure 1 : FY 2...
Need Help
  • ArwaAldoud's avatar
    ArwaAldoud
    1 year ago

    Hi POSPOS 

    try this 

    FY_Status =
    VAR HasFY24 = CALCULATE(COUNTROWS('Sample data'), 'Sample data'[FY] = "FY24", ALLEXCEPT('Sample data', 'Sample data'[Employee Name])) > 0
    VAR HasFY25 = CALCULATE(COUNTROWS('Sample data'), 'Sample data'[FY] = "FY25", ALLEXCEPT('Sample data', 'Sample data'[Employee Name])) > 0

    RETURN
    SWITCH(
    TRUE(),
    HasFY24 && HasFY25, "Both",
    HasFY24, "Dropped from FY24",
    HasFY25, "Added in FY25",
    "Unknown"
    )

ArwaAldoud's avatar
ArwaAldoud
Icon for Super User rankSuper User
1 year ago

Hi POSPOS 

try this 

FY_Status =
VAR HasFY24 = CALCULATE(COUNTROWS('Sample data'), 'Sample data'[FY] = "FY24", ALLEXCEPT('Sample data', 'Sample data'[Employee Name])) > 0
VAR HasFY25 = CALCULATE(COUNTROWS('Sample data'), 'Sample data'[FY] = "FY25", ALLEXCEPT('Sample data', 'Sample data'[Employee Name])) > 0

RETURN
SWITCH(
TRUE(),
HasFY24 && HasFY25, "Both",
HasFY24, "Dropped from FY24",
HasFY25, "Added in FY25",
"Unknown"
)