Calculate with allexcept does not work

[Jake_Neyu]

Hello,

I want to calculate the number of leads for each source for the table on the right and it should be the same as the number of leads for each source in table on the left. 

I am using calculate with allexcept but it doesnt seem to work.

[tamerj1]

@Jake_Neyu 
Are the columns involved in the hierarchy coming from the same table?

[Jake_Neyu]

Hi mate,

Yes, its all from 'tms' table

[tamerj1 · Accepted solution]

@Jake_Neyu 
This is due to Auto-Exist. Long story short, you have to have a date table and create a relationship with your table's date column.