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