Forum Discussion
Dividing data from one column from a visualization by a column in another visualization
Hi,
I have a visualization with a sum of the minutes of downtime by reason code. I also have a visualization with the count of the downtime occurrences by reason code. I would like to divide the minutes by the occurrences to get the average # of minutes per occurrence. I have a slider that sets the timeframe for the visualizations. I would like to accomplish this using the temporary tables created for the visualizations if possible, so my sliders still impact the data. Any help is greatly appreicated.
Thanks,
Charlie
Hello
Try to creat a measures:
Measure 1
Total Duration = sum("Duration")
Measure 2
No of Duration = count("Duration")
Measure 3
Ratio = divide (sum("Duration") , count("Duration"))
If you need more help share a pbix with some dummy values.
Best regards
Bruno Costa | Skilled Sharer
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍
Take a look at the blog: PBI Portugal
2 Replies
- onurbmiguel_
Power Participant
Hello
Try to creat a measures:
Measure 1
Total Duration = sum("Duration")
Measure 2
No of Duration = count("Duration")
Measure 3
Ratio = divide (sum("Duration") , count("Duration"))
If you need more help share a pbix with some dummy values.
Best regards
Bruno Costa | Skilled Sharer
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍
Take a look at the blog: PBI Portugal
Thank you Bruno,
I was over thinking this solution. Thanks again,
Charlie
