Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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:
@xiumi_hou can you share the sample data and expected result and also how you want it to behave when you filter the data?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi Parry, Thanks for asking.
Actually I would like to separate into two parts:
1. I have Five scliers: Year/Month/Group/User Name/Indicators
The goal is to monitor for a single month, what is the perforamce for user A's indicator A (I want to use actual value compare with group average as well as the target value).
I have created several measure for the actual value of each indicator, however, I do not know how to link the target value and how to calculate the average within group and link back to the actual value? below is the sample data:
2. The second condition is exactly same with the previous one, the quesiton is when I calculate average, I use function:
@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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
123 | |
78 | |
49 | |
38 | |
37 |
User | Count |
---|---|
196 | |
80 | |
70 | |
51 | |
42 |