Skip to main content
cancel
Showing results for 
Search instead 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

Reply
az38
Community Champion
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

 

tbl1tbl1

 

 

 

 

 

 

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


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
1 ACCEPTED SOLUTION
MFelix
Super User
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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

3 REPLIES 3
mobriladigo
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

 

tbl1tbl1

 

 

 

 

 

 

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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



az38
Community Champion
Community Champion

yeah, perfect! Thx1


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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors