Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Please help me for creating DAX compare to a SQL

Hi, Need to create DAX based on below SQl:   select SUM(EMDM_Support.ms.INVALID_RECORDS) from EMDM_Support.EDG_COUNT_STATUS ms inner join EMDM_Support.TGT_MAT_75 ch on ms.EDG_ID = ch.EDG_ID whe...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi,

    I am taking aplology  for that as because I have just discovered that my previous relation ship was not correct, in Many to Many relation ship there I just chnaged the filter condition to:  Single TGT_MAT_75 Filters EDG_COUNT_STATUS and it just solved the problem using the below DAX:

    Measure 3 = calculate(sum('EDG_COUNT_STATUS'[INVALID_RECORDS]),
    'EDG_COUNT_STATUS'[PROFILE_ID] =75,
    'TGT_MAT_75'[status]="Article Number has Invalid Length"
    )

     

    But thanks to you for being with me.