Create an Average calculation grouping by two different fields
I need to create the calculation for the avg score grouping by subtheme per each client(case ID). I created a expected output based on some inputs values: As you can see, first all i need to sum the score per subtheme, then divide each client score for the subtheme which its belongs. I have tried several formulas, such as: Nothing works as expected: sometimes the values returned are the same as the score field for each client/caseid, or either it just calculate the sum of the score/count(total clients), what is not true, sice the nominator will variate depending of the score oh that or other specific client per suntheme each belongs. If someone know how to solve it. i would appreciate a lot. 🙂Forecast Accuracy: Calculate the Category average based on percentages subcategories
Hello friends, I'm struggling with this issue for like a month, anybody could help me please? I have two tables: Forecast Table: Account Category Subcategory SubSubcategory Forecasted Value Actual Table: Account Category Subcategory SubSubcategory Actual Value I would like to calculate my forecast accuracy in two methods (like in the simplified table below) : - Weighted Average Accuracy (easy, I got this) - Non Weighted Average of the Subcategory Accuracies (in yellow) After this, I need to be able to filter the results by "Account" with a slicer on my dashboard. This will allow me to understand how well the Account has forcasted for each Category, Subcategory and the third is a KPI that kind of average the two. I think this could be done with some DAX VAR or GROUPBY but didn't manage to do make it right now.. Any ideas folks?Average per row, reseting on each month
Hello! First Post. I have data of my country's position on a ranking list. I need to determine the average of that position for each month separately. Currently im using: Promedio = CALCULATE( AVERAGE(PowerBI[Posición]); FILTER(PowerBI; PowerBI[Fecha].[Month]<=EARLIER(PowerBI[Fecha].[Month]) && PowerBI[Fecha].[Day]<=EARLIER(PowerBI[Fecha].[Day])) ) But the averages are wrongly calculated. I also noticed that on the first day of the month if position is 50 the average shows 55.5 which means its carrying values from the previous months. Please help me fix my formula. Thanks in advance.
