Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 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
Solved! Go to Solution.
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
@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
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.
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êsyeah, perfect! Thx1
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |