Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

DAX Measure giving error

Anonymous , I am trying to replicate one formula from Business Objects to Power BI DAX which reads as follows.   If ([Type] = "Charted") Then (If IsNull([vCountofChanges] Where([Calendar Days] >= ...
@Dax
@dax @help
@Dax help
@Dax Measure Error
@Daxhelp
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Anonymous 

    please try

    =
    IF (
    MAX ( 'Change Requests'[Type] ) = "Charted",
    SUMX (
    VALUES ( 'Change Requests'[Calendar Days] ),
    IF ( 'Change Requests'[Calendar Days] >= [LeadDays], [vCountofChanges], 0 )
    )
    )

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi tamerj1 ,

It worked perfectly 🙂 Thanks a lot for your help