Forum Discussion

VMP's avatar
VMP
Frequent Visitor
3 years ago

If else DAX Measure

I was able to create a calcuated column at row level calculation, but I have to calculate as measure. Please guide me on how to create a Measure rather than column? Below is DAX to create calcula...
eliasayyy's avatar
eliasayyy
Memorable Member
3 years ago

oh my bad 

we need to change target[amount] because we are using it in measures can you please let me know how you want it? like amount multiplies by 1 is row by row? or sum of it or the max ...

VMP's avatar
VMP
Frequent Visitor
3 years ago

The amount multiplies by 1 is row by row, I tried Sumx in your formula but still getting same error message.

  • eliasayyy's avatar
    eliasayyy
    Memorable Member
    3 years ago

    can you share the measure please

    • VMP's avatar
      VMP
      Frequent Visitor
      3 years ago

      I used same DAX function you had provided but instead of Max I used SELECTVALUE but that didn't worked so deleted.

      • eliasayyy's avatar
        eliasayyy
        Memorable Member
        3 years ago

        selected value usually doesnt work in some cases prefer to use values or max