How to count 2 condition?

[Anonymous]

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(

COUNTA('Update'[Status Date]),

EOMONTH('Update'[Status Date],-1)+1 = DATE(2021, 4, 1)

)

RETURN

IF ( ISBLANK ( __CurrentMeasure ), 0, __CurrentMeasure )

Please guide me  about it.

[v-luwang-msft]

Hi @Anonymous ,

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

 Data Type changes to "Text": Data:Column =FORMAT('Calendar'[Date],"yyyymmyy") 

"Text"  Type changes to Data:Column = VALUE(FORMAT(TODAY(), "YYYYMMDD"))

If question still unsolved ,could you pls share your pbix file? Remember to remove confident data.

Wish it is helpful for you!

Best Regards

Lucien

[Jihwan_Kim]

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]

@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.

[Anonymous]

@Jihwan_KimIt 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.

[Jihwan_Kim]

Hi, @Anonymous 

Thank you for your feedback.

Please share your sample pbix file's link here, then I can try to look into it to come up with a more accurate measure.

Thanks.

[Anonymous]

@Jihwan_KimI can't send .pbix file to you.

If I share file excel that I use read in power bi.

Are you okay?

[Jihwan_Kim]

Hi, @Anonymous 

Yes, please share your excel file with mentioning how you want to show in visual, for instance, table visual or bar chart, or any others.

[Anonymous]

@Jihwan_Kim @v-luwang-msft  file excel example : file excel input 

I want to count status (2021) = Complete and status date = april 2021

I want to show amount count in card visual.

Please guide me about it.

[Jihwan_Kim · Accepted solution]

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