Convert CountIf to Dax

[Anonymous]

Hello, 

I know there are some other post here but reviewing them I am still having issues getitng my data to format correctly. 

I am trying to take this formula and get it to work in power bi: =COUNTIF(ProjectInfo!B:B,ProjectInfoCount!B1)

Any help would be greatly appriciated. If i figure out an answer I'll post it.

Thanks!

~Chris

[v-jiascu-msft]

Hi @Anonymous,

Could you please mark the proper answers as solutions?

Best Regards,

[Anonymous]

Sorry I was going to get to it but have been tied up. 

[Ashish_Mathur]

Hi,

Share some data and show the expected result.  I should be able to paste your data in an Excel file.

[Anonymous]

Thanks! Here's the expected result in Excel and some data!

Expected results

Example Data, Values would be, Yes, No and - it wouldn't let me upload a file

[Ashish_Mathur]

Hi,

I cannot do anything with this.  I need data in a format which i can paste in an Excel file.

[Anonymous]

Sorry for miss understanding, didn't realize pasting data would come into a useable format!

Proj Info PD	Proj Info SD	Proj Info DD	Proj Info CD	Proj Info CA	Base Number
-	-	-	-	-	002002
-	-	-	-	-	002014
-	-	-	-	-	003026
-	-	-	-	-	003043
-	-	-	-	-	003043
-	-	-	-	-	003043
-	-	-	-	-	003060
-	-	-	-	-	003060
-	-	-	-	-	003112
-	-	-	-	-	003112
-	-	-	-	-	003112
No	No	No	No	No	003113
-	-	-	-	-	003113
-	-	-	-	-	003113
No	No	No	No	No	003113
No	No	No	No	No	003113
No	No	No	No	No	003113
-	-	-	-	-	003113
-	-	-	-	-	003140
-	-	-	-	-	003140
-	-	-	-	-	003140
Yes	Yes	Yes	Yes	Yes	003140
Yes	Yes	Yes	Yes	Yes	003140
Yes	Yes	Yes	Yes	Yes	003140
-	-	-	-	-	003140
Yes	Yes	Yes	Yes	Yes	003140
-	-	-	-	-	003434
-	-	-	-	-	003434
No	No	No	No	Yes	003449
-	-	-	-	-	003449
-	-	-	-	-	003449
-	-	-	-	-	003449
No	No	No	No	No	003526
No	No	No	No	No	003526
-	-	-	-	-	003569
-	-	-	-	-	003569
-	-	-	-	-	003569
-	-	-	-	-	003569
-	-	-	-	-	003569
-	-	-	-	-	003640
-	-	-	-	-	003640
-	-	-	-	-	003640

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

Would like something like below? Please download the demo from the attachment? 

Best Regards,

[Ashish_Mathur]

Hi,

I am not clear about your expected result - from your initial post, your expected output is not clear.

[Anonymous]

Thanks! Here's the expected result in Excel and some data!

Expected results

Example Data, Values would be, Yes, No and - it wouldn't let me upload a file