Create a calculated measure based on a column and measure

[nmartinovic]

Hello,

I would like to create a table within Power BI Desktop.  I have a benchmark column, and a closed ticket measure.  I would like to create a new value that is the first two values multiplied by one another.  When I try and do this I get an error.

Any ideas?

Category Tier	Benchmark	Closed Tickets	Ticket Factor
MDA	2	1	2
WEDCS	4	2	8
BlueKaik	6	3	18

Sincerely,

Nick

[Rémi · Accepted solution]

Hi,

The problem is that you need to apply a calcul on your column before multiply it with your measure.

You have several solutions for that :

Sum first then multiplication :

New Measure = SUM( [benchmark] ) * [closed ticket]

Multiplication then sum :

New measure = SUMX( 'YourTable' ; [benchmark] * [closed ticket] )

You can use SUMMARIZE fonction if the situation is more complicated, but those examples is sufficient to my opinion.