Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am very new to Power BI and I am tring to work out how to add a calculation to a visualisation.
I have two values based on counts and I want to calculate the average number of jobs per trip.
Any help or advice would be great.
Solved! Go to Solution.
@smithshire , If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
If these two are measure then a new measure
Avg Job = divide([Jobs], [Trips])
@smithshire , If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
If these two are measure then a new measure
Avg Job = divide([Jobs], [Trips])
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |