Forum Discussion

cdawidow's avatar
cdawidow
Icon for Helper III rankHelper III
5 years ago

Dynamically Using SUM X for allselected values

Hi guys I have a simple measure called Average Sales = AVERAGEX(VALUES(FISCAL YEAR),TOTAL SALES)) Which is essentially calculating the average of total sales across all present years.    The formu...
DAX
Help Requested
sumx
cdawidow's avatar
cdawidow
Icon for Helper III rankHelper III
5 years ago

Thanks for the response.  Yes, I understand that values removes duplicates. 

 

But lets say I have 2 columns each with unique values ( Customers and Products) along with my average sales measure stated above.

 

Is there a way to build  a sumx calculation that follows the following rules:

 

If(Hasonevalue( column name),average sales, sumx(column name),average sales)