The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
87 | |
75 | |
53 | |
45 |
User | Count |
---|---|
135 | |
121 | |
77 | |
65 | |
64 |