Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
edavila
Helper II
Helper II

Averages

is there a way to get the average percentage of these 3 columns in the totals, I dont seem to find a way, I will like to have an average of the YOY growth %, dont know why in the total is getting the last balance of 2017

 

question.PNG

9 REPLIES 9
erik_tarnvik
Solution Specialist
Solution Specialist

There is no way to tell unless you provide the formulas and data you used to arrive at this result.

What exactly do you need to see

 

thanks for your help

What do the table(s) that are the source for your results look like? And, what formula did you use for the growth calculations?

this is the formula for the cases YOY

YOY Cs Growth % = divide([YTD Cases] - [YTD Cases Prev], [YTD Cases Prev],0)

 

for sales

YoY Growth % = DIVIDE([YTD Sales] - [YTD Sales Prev], [YTD Sales Prev],0)

 

does this help

 

BTW there is probably a way to get the totals to come out the way you want, but you would have to share the definition of all measures used in your definitions above. And any measure used in those measures and so on. 

Thanks for your help and do you need to see the pbix or how you cna help me

 

thanks

Hi @edavila,

Have you resolved your issue? If you have, welcome to share your solution, so that more people will find workaround easily.

Best Regards,
Angelia

Sure that would be ideal. If you can share through OneDrive or DropBox I'll see if I can figure it out. If you don't want to share your data with everyone on the internet, just send me a private message with the url for the data.

Yes, somewhat. The problem here is that it is not intuitively obvious what a "total" of these YoY columns actually means. From the information you have provided my assumption is that to form the total, the measures are evaluated in the context of all three years, but that still means that the YTD for those three years still evaluates to YTD for this year, and the same applies for the previous year in order to calculate the growth. In some way, this is also reasonable interpretation of what that "Total" should mean, but I understand it is not what you want. 

 

The way I would go about this is to remove the total in the table as it is hard to understand what it means anyway. If the average you want is still of value to the user, create a separate visual for that specifically that also clarifies for the user what it is exactly he or she is looking at.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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