Forum Discussion
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...
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 , based on what I got If you have an event available as a dimension. You can create a table using enter data and join it with the event table
How to Enter Data and Edit it: https://youtu.be/5nE7YGT72kU
or create a measure
Switch(Max(table[event]) ,
"Outreach",40 ,
"Relationship Building" ,20 ,
"Sponsored Events" , 20,
"Sales Finalized", 40
)
and use that