Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Table averages not calculating properly when using a measure

Hi everyone,   Hopefully an expert can help me solve this issue I'm having currently.    I have a chart which is visualized based on category and date using the following measure:   SKU Mix P...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , That is a simple avg for that you need a measure like

 

Averagex(Values( 'SKU Mix[Category] ) , DIVIDE (
CALCULATE ( SUM ( 'SKU Mix'[Qty] )),
CALCULATE ( SUM ( 'SKU Mix'[Qty] ), ALLEXCEPT ( 'SKU Mix','SKU Mix'[Date] ) )
))

 

You can use line in line Stacked column bar visual

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks for the response! 

 

So if I were to add one more top-level category that the SKU Mix (Category) is broken down into. How would I incoporate that? Currently if I add a "Product" filter, the percentages don't change dynamically to equal a total of 100% anymore.

 

Example (added a "Product" column which groups the Category" column into larger overall groups: