Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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])))

 

Date[ST_dt] is a slicer.and Date and Dim2 have relationship on Date[ST_DT] nad 'dim2'[Date].

So when i select particular date it filters the table2 but it is not filtering table1.

 

Col1 has 1,2,3 distinct value so it is giving 3 output.

 

But in table if u drag Col1 and dim2[Date] it is showing zero records as my Fact is empty.

So i need output blank or 0  when user selects the date.cause i dont have data in fact.

I don't know why it is not filtering table1 as well cause dim1 and dim2 have relationship.

4 Replies

  • 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?

    • Anonymous's avatar
      Anonymous
      Not applicable

      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

      • Anonymous's avatar
        Anonymous
        Not applicable

        if i drag provider_id and effective date in same table visual it is showing blank. But measure is showing 3