cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Community Champion

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

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

do not hesitate to give a kudo to useful posts and mark solutions as solution
1 ACCEPTED SOLUTION
Super User

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

Regards

Miguel Félix

Proud to be a Super User!

Check out my blog: Power BI em Português

3 REPLIES 3
New Member

@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

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.

Super User

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

Regards

Miguel Félix

Proud to be a Super User!

Check out my blog: Power BI em Português

Community Champion

yeah, perfect! Thx1

do not hesitate to give a kudo to useful posts and mark solutions as solution