Calculating 2 card values into 1 card

[PDYHORA]

Hi,

I currently have 2 cards that sum up different information

1 - sums up the hours of a negative impact event

2 - sums up the total operating hours

I want to calculate these 2 values to get a percentage on a card (1/2), so that it moves depending on the various filters (month, user, etc.)

How would I go about doing this?

Thanks!

[PDYHORA]

Hi,

I currently have 2 cards that sum up different information

1- sums up the hours of a negative impact event

2- sums up the total operating hours

I want to calculate these 2 values to get a percentage on a card (1/2), so that it changes depending on the various filters (month, user, etc.).

How would I go about doing this?

Thanks!

[Greg_Deckler]

Create a measure like:

Measure = DIVIDE(SUM([negativeimpactevent]),SUM([totaloperatinghours]))

Assuming you have those columns.

[Anonymous · Accepted solution]

Measures are the key to doing this.  Each card, you could create a measure that does 1 and 2.  Then you can create a 3rd measure that takes the result of 1 and 2 and does whatever you need.

If your cards have their own set filters, you could include these into your measures themselves as well.  An example might be:

NegativeImpact = CALCULATE(
	SUM('YourTable'[Hours]),
	'YourTable'[WasNegative] = 1	
)

Total Operating Hours = Sum('YourTable'[Hours])

Negative% = DIVIDE(
	[NegativeImpact],
	[Total Operating Hours]
)