Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
Help appreciated solving a Power BI data manipulation issue.
I have a table with multiple columns that i have successfully turned into multiple measures by grouping different collections together to get a range of different totals.
The measures are AverageX, so I can slice the data at a location level, or grouped by region or nation or by any other filter.
Now I would like to work on Gap analysis, so, for one measure how does any individual location's result compare to the average for that measure.
Ideally the average being used would be dynamic, i.e Location vs national average, or regional average, or average sliced by infrastrucutre on site etc.
You cannot measure a measure. Re-implement the entire business logic in a new measure.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |