Forum Discussion

Austinehype's avatar
Austinehype
Helper I
5 years ago

Table dax

Hi!   I have a table with revenues and different type of products. The problem is there are some products where the value is 0 hence I would like to take the average revenue value of that product i...
Need Help
Austinehype's avatar
Austinehype
Helper I
5 years ago

Hi PaulDBrown 

 

Thank you for your quick support, I have tried the formula into my table it's not bad but it's not showing the excact average amount as per below

Column C is where I took the average revenue of each product name.

Column D is the measure you provided it's slightly different and doesn't reflect the excact average amount from column C.

 

Where the Product revenue value is 0, I expect the "Average Revenue"(column C) in my table

 

 

Thank you

v-yingjl's avatar
v-yingjl
Community Support
5 years ago

Hi Austinehype ,

Basically the measure created by @ PaulDBrown should work in the report. Could you please consider sharing a sample file without any sesentive information or sample data for further discussion? In your posted picture could not confirm what is your expected output.

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.