multiple tab in excel as source

[sraj]

Hi Everyone,

I have an excel spreadsheet with several tabs which is on one drive and has to be used as it is.  

First I had to show the Percentage based on the sum of Completed/ sum of Enrolled, which is on one tab of the excel sheet

Division Percent Complete = SUM([Completed]) / SUM(Leaderboard[Enrolled Training])

Now I am required to show Division Percent complete of only who passed and the Passed field that is in the other tab of the excel sheet For e.g. sum of Completed/ sum of Enrolled if they Passed

Can someone please advise on how I can acheive this?  

[MFelix · Accepted solution]

Hi @sraj ,

To make this work you need to create a table for each of the tabs in your excel spreasheet so you need to have one table for the enorrled and another for the passed.