Forum Discussion
Measure showing wrong calculation
Hi, I have tables fact,dim1,dim2 and dim1 and dim2 have relationship with fact. My measure is Loc_Count=Calculate(Distinctcount('dim1'[col1])),filter('dim2','dim2'[Date]>Selectedvalue('Date'[st_DT]...
Anonymous you have provided lot of info but still missing important info on your post.
Can you share relationship diagram and what you want your output to be?
See i have 3 tables one is provider having provider id and another is proivder network having effective date and term. date and i created manually date table with start date and end date columns and is mapped on effective date and start date