topic Calculate average for selected ID in DAX Commands and Tips

Calculate average for selected ID

DionTN — Tue, 11 Oct 2022 15:11:58 GMT

This is the example i want.

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

Jihwan_Kim — Tue, 11 Oct 2022 17:30:50 GMT

Hi,

Please check the below picture and the attached pbix file.

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

DionTN — Sat, 22 Oct 2022 08:58:26 GMT

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

Jihwan_Kim — Sun, 23 Oct 2022 14:11:45 GMT

Hi,

May I ask how does your desired outcome look like?