Calculate the count of words and then add hours infront of it.

[Anonymous]

Hello, 

I have this type of leaves.

what I want to do is calculate the count of every leave individually then add the hours infront of it.

For example NT count is 10 then add all the hours 10 times. 

If count of SL is 4 then add all the hours 4 times.

this is just a reference image there are hours value can be any not always 8.5. sometimes 10, 4 , etc 

just need the sum of it by leave count.

I want to make a measure. 

thanks 

[v-diye-msft]

Hi @Anonymous 

Not quite understand the requirements, please kindly elaborate more with detailed data and expected results. dummy pbix is appreciated.

[Greg_Deckler]

Not entirely certain I have this, but maybe put your "Leave" column in a visual and then use this measure:

Measure =
  VAR __Count = COUNTROWS('Table')
  VAR __Sum = SUM('Table'[Hours])
RETURN
  __Count * __Sum