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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Bring table EMDM_Support.ms. and EMDM_Support.EDG_COUNT_STATUS to power bi and join then on EDG_ID.
I am assuming it would be 1 to many or many to 1

 

calculate(sum('EMDM_Support.EDG_COUNT_STATUS'[INVALID_RECORDS]),'EMDM_Support.EDG_COUNT_STATUS'[PROFILE_ID] =75,'EMDM_Support.ms.INVALID_RECORDS'[status]="Article Number has Invalid Length")

 

Correct table name as per need.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous Does the above reply helps. if you need more help make me @

Appreciate your Kudos.