Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Januar | Januar | Feb | Feb | March | March | April | April | Avergage | Avergage | |
speed | Velocity | speed | Velocity | speed | Velocity | speed | Velocity | speed | Velocity | |
Truck 1 | 71% | 69% | 75% | 78% | 42% | 48% | 87% | 78% | ||
Truck 2 | 78% | 15% | 14% | 46% | 71% | 69% | 75% | 87% | ||
Truck 3 | 77% | 68% | 42% | 65% | 68% | 78% | 45% | 52% | ||
Truck 4 | 71% | 69% | 78% | 72% | 89% | 69% | 85% | 79% |
I would like to calculate the average speed and velocity and display them at the end of the table, as shown above. I am curious if there is a way to show the average as a percentage of the months displayed in the table. Any guidance on how to achieve this would be greatly appreciated. Thank you very much.
Solved! Go to Solution.
Hi @surajbh ,
First of all, many thanks to @bhanu_gautam for your very quick and effective replies.
Based on my testing, please try the following methods as workaround:
1.Create the simple table.
2.Create the new measure to calculate average.
Average =
VAR valu_ = SUM('Table'[Values])
VAR spee = CALCULATE(SUM('Table'[Values]), ALLEXCEPT('Table', 'Table'[Truck], 'Table'[Sped]))
VAR spe_count = DISTINCTCOUNT('Table'[Month])
VAR result = DIVIDE(spee, 4)
RETURN
result
3.Drag the measure into the matrix visual.
4.Change the measure format to the percentage.
5.The result is shown below.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @surajbh ,
First of all, many thanks to @bhanu_gautam for your very quick and effective replies.
Based on my testing, please try the following methods as workaround:
1.Create the simple table.
2.Create the new measure to calculate average.
Average =
VAR valu_ = SUM('Table'[Values])
VAR spee = CALCULATE(SUM('Table'[Values]), ALLEXCEPT('Table', 'Table'[Truck], 'Table'[Sped]))
VAR spe_count = DISTINCTCOUNT('Table'[Month])
VAR result = DIVIDE(spee, 4)
RETURN
result
3.Drag the measure into the matrix visual.
4.Change the measure format to the percentage.
5.The result is shown below.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-jiewu-msft thank you for the file and answer. well apperciate it.
i see average is always repeated in the column,
but i would like to show at the end of the table, like the way total is shown but would like to show average ( in %) in the last column.
i think when writing the formula in average, i should write something so that it ignore it on the month columns but shows in the last column only.
could you please help if possible, any lead is always appreciated.
thanks.
@surajbh , You can create a simple measure for Average speed and Average Velocity
Average Speed = AVERAGE('TableName'[speed])
Average Velocity = AVERAGE('TableName'[velocity])
And for Percentage you can use this measure
Average Percentage = DIVIDE([Average Speed], COUNTROWS('TableName') / COUNTA('TableName'[speed]) * 100, 0
Proud to be a Super User! | |
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
71 | |
43 | |
21 | |
21 | |
14 |
User | Count |
---|---|
124 | |
42 | |
39 | |
28 | |
24 |