Forum Discussion
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?
Hi,
Please check the below picture and the attached pbix file.
Score expected measure: = IF ( HASONEVALUE ( Data[ID] ), AVERAGE ( Data[Score] ) * 10 )
3 Replies
Hi,
Please check the below picture and the attached pbix file.
Score expected measure: = IF ( HASONEVALUE ( Data[ID] ), AVERAGE ( Data[Score] ) * 10 )Jihwan_Kim Can i also do this when i want to combine ID's? For example A & B?
Hi,
May I ask how does your desired outcome look like?
