Forum Discussion

CJ_96601's avatar
CJ_96601
Helper V
6 years ago

DATA MODEL

Hello,    I have 4 facts table and have this model as follows:     Table 1                                        Key Index      - Emp No      - Hire Date      - Termination Date   Table 2 ...
CJ_96601's avatar
CJ_96601
Helper V
6 years ago

camargos88 

 

It is not that easy...considering how oracle is .

 

thanks for the link.  

CJ_96601's avatar
CJ_96601
Helper V
6 years ago

camargos88 

 

On another note, i know this is not related to my previous question, please refer to the screen shot below:

 

 

Why bar graph ended up that way , when using below measure?

 

 

  CALCULATE(DISTINCTCOUNT(ODBC[EMPNO])+0,
USERELATIONSHIP(ODBC[TERMDATE], 'Calendar'[Date]),
not(ISBLANK(ODBC[TERMDATE])+0),

ODBC[REASON]="TRANSF") - // THIS SUPPOSE TO FILTER
 
Secondly, can i use "<= CALENDAR[DATE]" with the above measure?
 
Regards,
 
 


  • camargos88's avatar
    camargos88
    Community Champion
    6 years ago

    CJ_96601 ,

     

    It looks like a problem with your model design, check the table connections.

    Would help if you post how you are connections those tables. But try to be simple with the model, redesign it with the append ou union.

     

    Ricardo