Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to Divide/Multiply Rows in Matirx by Fixed values in a Column

Hello and thank you in advance for reading this post. I have a matrix that I am creating and I need to divide a row I created in the Matrix with a fixed column of numbers. This is a simple task in Ex...
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi Anonymous 

    Try this,

    Calculated column code:

    Percentage of Goal = 
VAR _CountOfType =
    CALCULATE (
        COUNT ( Table1[Type] ),
        FILTER ( ALL ( Table1 ), Table1[Event] = Table2[Event] )
    )
VAR _Goal = Table2[Goal]
RETURN
    DIVIDE ( _CountOfType, _Goal )
    Column = Table2[Maximum points]*Table2[Percentage of Goal]

     

    Best Regards,

    Community Support Team _Tang

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

v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

Hi Anonymous 

Try this,

Calculated column code:

Percentage of Goal = 
VAR _CountOfType =
    CALCULATE (
        COUNT ( Table1[Type] ),
        FILTER ( ALL ( Table1 ), Table1[Event] = Table2[Event] )
    )
VAR _Goal = Table2[Goal]
RETURN
    DIVIDE ( _CountOfType, _Goal )
Column = Table2[Maximum points]*Table2[Percentage of Goal]

 

Best Regards,

Community Support Team _Tang

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank You! I really appreciate your assistance!