Forum Discussion
Question Regarding calculate group average
Dear allI was trying to calculate different indicators' average by group. The avergae is total number of cases/total number of people. When I put my dax function as below: Count_Average_Closed_Cas...
xiumi_hou im not fully clear about your requirement. Could you plese share data in excel file and put expected result in a sheet explaining calculation and will get you the solution.
Hello Parry,
Please find the attached excel document. I want to create a chart with the actual value compare with average and target. For example, when I choose the year 2017,month Aug, Group A, User: Sample 1, Indicator: Assessment, I would like to see this users;s actual value(how many assessment held in that month) with target and group A's average in one chart.
Below is the sample data:
https://1drv.ms/x/s!AlqPFuio7_SNielZyCarJMba9i1MfQ
Please let mw know if you need more information. Thanks!! parry2k