Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Problem with Average of a Count

I have this data set that I used for a pivot table in Excel in which it counts the number of projects per practice:    # of Completed Projects Per Practice     2020 2021 2022  YES  6 6...
General Comment
Need Help
Tips and Tricks
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi,

Please check the below picture and the attached pbix file whether it suits your requirement.

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I'm trying to get the dax for the second table

    • v-easonf-msft's avatar
      v-easonf-msft
      Icon for Community Support rankCommunity Support
      3 years ago

      Hi， Anonymous 

      Did Jihwan_Kim ‘s solution not work for you?

      If your problem has been solved, you could accept the helpful answer as solution.

      If you still need help, please share more details.

       

      Best Regards,
      Community Support Team _ Eason