Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Calculating IF at row level

Hi, Can anyone suggest where I am going wrong please? I need to create a measure that gives a classification to a row, based on the result of another measure. I have to create this as a measure as I...
DAX
if
Row
milanpasschier2's avatar
milanpasschier2
Icon for Helper I rankHelper I
4 years ago

Hey, can you share some sample data in a xlsx/pbix file? Also I would rather work with SWITCH instead of multiple if statements for readability purposes.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi, applogies, I don't seem to be able to attach anything. I am wondering if because [Duration Minutes] and [Planned Minutes] are measures, this is why it is not working at row level, because they are already aggregated?