Calculated Measure

[Anonymous]

I'm attempting to create a measure that assigns a dollar amount based on [tier] and [nps level], but I need it to be in a format that I can add/sum/etc. Currently I can insert a number, but for whatever reason it isn't totaling or anything. How can I go about setting that up?:

[Anonymous]

Hey @Anonymous

Try this:

Bonus =
IF(
   [NPS Level] = "NPS Silver" && [Tier] = "3",
   30,
   SUMX(
      Table,
      IF(
         [NPS Level] = "NPS Silver" && [Tier] = "3",
         30,

         0

      )

   )

)

Hope this helps,

Parker

[KHorseman]

You've told it to only assign a value of 30 if both [NPS Level] = "NPS Silver" and [Tier] = "3". On the total row, the Tier is 1. Also there's no math in your formula so if you're expecting it to sum up all the 30's you're going to be out of luck. It will just enter 30 if the total row shows a tier of 30. You would probably need to nest this inside a SUMX to add up all the 30 values.

[Anonymous]

@KHorseman I see, that makes sense. I'm trying to work towards building a model like this, I really just don't know how or where to begin. Complex beyond what I know how to do in Power BI: