Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

If Condition Need help

Hi, I've below DAX logic for my chart.  I've tried but no luck. Can someone help me on this one?   IF  CALCULATE(count(CM[Change ID]),CM[Overdue / Not overdue]="Not Overdue")        is <1   the...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi Anonymous ,

     

    Please create a measure like this.

    Measure = 
IF ( 
    CALCULATE(
        COUNT(CM[Change ID]), 
        FILTER(
            ALLSELECTED('CM'),
            CM[Overdue / Not overdue] = "Not Overdue"
        ) 
    ) < 1 , 
    CALCULATE(
        COUNT(CM[Change ID]), 
        FILTER(
            ALLSELECTED('CM'),
            CM[Overdue / Not overdue] = "Not Overdue" && CM[CMLastMonthYear] = 1
        )
    ) ,
    "No Data Message"
)

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi Anonymous 

If you provided your data and/or PBIX it woudl be easier to work on this.

Try this

IF ( 
    
    CALCULATE(count(CM[Change ID]), CM[Overdue / Not overdue] = "Not Overdue") < 1 , 
    
    CALCULATE(count(CM[Change ID]), CM[Overdue / Not overdue] = "Not Overdue" && CM[CMLastMonthYear] = 1) ,
    
    "No Data Message"

    )

Regards

Phil

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Philip,

Thanks for your reply. I get below error msg.

 

For uploading pbix file/Data. I do not see any option to upload. Thanks!