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]...
if i drag provider_id and effective date in same table visual it is showing blank. But measure is showing 3
So i need dax which count distinct proivder ids when effective and termination date is in range of selected date values by user