Solved: Calculate average for selected ID

DionTN · ‎10-11-2022

This is the example i want.

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

Jihwan_Kim · ‎10-11-2022

Hi,

Please check the below picture and the attached pbix file.

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Jihwan_Kim · ‎10-11-2022

Hi,

Please check the below picture and the attached pbix file.

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

DionTN · ‎10-22-2022

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

Jihwan_Kim · ‎10-23-2022

Hi,

May I ask how does your desired outcome look like?

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Calculate average for selected ID