Forum Discussion

az38's avatar
az38
Icon for Community Champion rankCommunity 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

 

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

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

     

3 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    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.