Help setting up data structure/relationships

aashton 

why you need all the bidirectional filters . 

i would recommend to get rid off the bidrectional filters .

bi directional filters make your DAX hard to interpret and debug. 

other than that, it all depends on your needs .

for you case, 

get the total number of leads by source : you can get this data from the source and leads source table 

get the total number of applications by source : i assume this is the requirement that because of it, you created the bi directional filters. 

i would recommend to remove all the bi directional filters and activate the bi directional filter just in the calculation of the measure, using crossfilter. 

calculate

(

[measure] ,

crossfilter ( tbl_name[col_1], tbl_name[col_2] , both ) 
)

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠