Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Convert CountIf to Dax

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

Need Help

9 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    7 years ago

    Hi,

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        7 years ago

        Hi,

         

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

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Anonymous,

     

    Could you please mark the proper answers as solutions?

     

     

    Best Regards,

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

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