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 )
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?