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               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

     

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

 

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
7 years ago

yeah, perfect! Thx1