Completion percentage based on multiple tables

[Maz_0102]

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

[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.

[v-jianboli-msft · Accepted solution]

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_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?

[Maz_0102]

You are a genius man. This works perfectly. 

can you recommend any good courses I should to enhance my power BI skills please