Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Multiplier depending on critera

Hello,   I would like to create a measure or column based off critera that will dicate to multiply a set of data or not. In the table below, I would like to multiply anything that has the channel o...
Need Help
  • d_rohlfs's avatar
    d_rohlfs
    3 years ago

    Hey there Anonymous,

    What you need to do is create a DAX Calculated column. The formula should look like this:

    Column Name = If('Table'[Channel] = "Disty", 'Table'[Cost] * 1.06, 'Table'[Cost])

     


    If this is correct please think about marking it as a solution.

  • Syk's avatar
    Syk
    3 years ago

    Oh you're saying you just don't want the Direct cost? Only disty?

    Disty Cost = CALCULATE (
        SUM ( 'table'[cost] ),
        'table'[Channel] = "Disty"
    ) * 1.06

     

Syk's avatar
Syk
Resident Rockstar
3 years ago

You're trying to sum this up by company? A little confused by this response.
Right now this is what I'm showing by copying your example.

If you set Cost to sum, you'll get 


And if you want it rolled up by company, just remove the other details

 

 



Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hey Syk That is correct. Trying to sum things up by each company. So if I choose Company A, I just want back the sum of the disty cost by company A. I want to be able to do that with each company I select. 

  • Syk's avatar
    Syk
    Resident Rockstar
    3 years ago

    Oh you're saying you just don't want the Direct cost? Only disty?

    Disty Cost = CALCULATE (
        SUM ( 'table'[cost] ),
        'table'[Channel] = "Disty"
    ) * 1.06

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      This is exactly what I needed! Thank you so much!