Forum Discussion

az38's avatar
az38
Community Champion
7 years ago
Solved

measure inside measure

Hello!   Im sure its prety easy question, but i dont feel perfect in this topic.  So, I've got a table               There is a TotalTierTarget - new measure which calculated using a...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    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

     

mobriladigo's avatar
mobriladigo
New Member
7 years ago
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.