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

 

___measure =
VAR disty =
    CALCULATE (
        SUM ( 'table'[cost] ),
        'table'[Channel] = "Disty"
    ) * 1.06
VAR other =
    CALCULATE (
        SUM ( 'table'[cost] ),
        'table'[Channel] <> "Disty"
    )
RETURN
    other + disty

 

Will this work for you?

Syk's avatar
Syk
Resident Rockstar
3 years ago

Now you have a solution for a column or a measure!