Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Row level calculation that adds rows

Hi everyone,   I am facing a new issue on my PBI. I have a table in the following format (rand = random number) :   month product value dec a rand a dec b rand b dec c rand c ...
Need Help
thumma's avatar
thumma
Frequent Visitor
2 years ago

Hi Anonymous you can use the below dax to achieve the desire result.

Column = IF('Table'[product] = "d", CALCULATE(SUM('Table'[value]), 'Table'[product] = "c") * 10, 'Table'[value])

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Thank you
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thank you. However, this is not exactly what I want. Product "d" doesn't exist at all in my first table, I want to create it