Forum Discussion

DionTN's avatar
DionTN
Icon for Helper II rankHelper II
3 years ago
Solved

Calculate average for selected ID

This is the example i want. 

I have this imported in Power BI. How can i add this formula in DAX? 

 

Help
Tutorial
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Please check the below picture and the attached pbix file.

     

     

     

    Score expected measure: =
IF ( HASONEVALUE ( Data[ID] ), AVERAGE ( Data[Score] ) * 10 )

3 Replies

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

     

     

     

    Score expected measure: =
IF ( HASONEVALUE ( Data[ID] ), AVERAGE ( Data[Score] ) * 10 )
    • DionTN's avatar
      DionTN
      Icon for Helper II rankHelper II
      3 years ago

      Jihwan_Kim Can i also do this when i want to combine ID's? For example A & B?

      • Jihwan_Kim's avatar
        Jihwan_Kim
        Icon for Super User rankSuper User
        3 years ago

        Hi,

        May I ask how does your desired outcome look like?