measure inside measure

[az38]

Hello!

Im sure its prety easy question, but i dont feel perfect in this topic. 

So, I've got a table

tbl1

There is a TotalTierTarget - new measure which calculated using another table.

What I need - just new measure (or maybe column) in tbl1 percent = downDurationSec/TotalTierTarget

Could you advice me solution?

upd. Ishould notice that downDurationSec - its a grouped value via 'Sum' option

[mobriladigo]

---

@az38 wrote:

Hello!

Im sure its prety easy question, but i dont feel perfect in this topic. 

So, I've got a table Torrent TurboTax Gogoanime

tbl1

There is a TotalTierTarget - new measure which calculated using another table.

What I need - just new measure (or maybe column) in tbl1 percent = downDurationSec/TotalTierTarget

Could you advice me solution?

upd. Ishould notice that downDurationSec - its a grouped value via 'Sum' option

---

Try not to have any subtle elements on your information yet taking a gander at what you have kept in touch with you should utilize a measure this way:

Percent = SUM(Table[downDurationSec]/[TotalTierTarget]

This should work then simply organize this measure as rate.

[MFelix · Accepted solution]

Hi @az38,

Don't have any details on your data but looking at what you have written you should use a measure like this:

Percent = SUM(Table[downDurationSec] / [TotalTierTarget] 

This should work then just format this measure as percentage.

Regards,

MFelix

[az38]

yeah, perfect! Thx1