Forum Discussion
Helper ICompletion percentage based on multiple tables
Name is from source table
No. TBT compeleted is from souce table
Month name is from month table
#TBT required is from TBT table
I am using month table to make the relationshiop so i know how many TBTs were required for each month and align with how many people have actually completed
I want to work out the completion percentage based on the number of TBTs required
eg the completion pass rate for the first row should be 89% as he completed 8 out of 9
Please can anyone advise with a formula
i would really appreciate it
Hi Maz_0102 ,
Based on your description, I have created a simple sample:
Please try:
Measure = DIVIDE(MAX('Source'[No. TBT Compeleted]),MAX('TBT'[#TBT required]))Change the format of the measure:
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
v-jianboli-msftCommunity Support
Hi Maz_0102 ,
Based on your description, I have created a simple sample:
Please try:
Measure = DIVIDE(MAX('Source'[No. TBT Compeleted]),MAX('TBT'[#TBT required]))Change the format of the measure:
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Maz_0102You are a genius man. This works perfectly.
can you recommend any good courses I should to enhance my power BI skills please
- Maz_0102
Hi v-jianboli-msft, I can see a small issue
my TBTs required columns, the totals is not adding up properly. it's on 11,
can you advise?
- v-jianboli-msft
Hi Maz_0102 ,
If the #TBTs Required you used in the visual is column, please check the aggregation of the column and change it to Sum.
Or if it is a measure, please check the DAX.
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.