Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to count 2 condition?

Now I count status Date = 2021 04 01 but I want to count status Date = 2021 04 01  and status = Complete I have DAX as below. Count of Implement Status Date = VAR __CurrentMeasure = CALCULATE( ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Anonymous 

    I am not sure how your data type in your pbix file looks like, but I think you need to have a date-type column in the table.

    Please check the below pbix file's link.

     

     

    https://www.dropbox.com/s/xbgle5ipajq5i83/adamasmay.pbix?dl=0 

     

     

    Hi, My name is Jihwan Kim.

     

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, Anonymous 

Please try the below.

 

Count of Implement Status Date =
VAR __CurrentMeasure =
CALCULATE (
COUNTA ( 'Update'[Status Date] ),
EOMONTH ( 'Update'[Status Date], -1 ) + 1
= DATE ( 2021, 4, 1 ),
'Update'[Status] = "Complete"
)
RETURN
IF ( ISBLANK ( __CurrentMeasure ), 0, __CurrentMeasure )

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

Anonymous's avatar
Anonymous
Not applicable
5 years ago

@Jihwan_Kim It show error can't load data from image.

It errorshow DAX not support compare date and text. Please try function Value or format for convert.

Please guide me.