Using distinct twice in one measure

[Grinch356]

Hi,

I have a measure in powerpivot:

Mix % Measure Avg:=averagex(DISTINCT(Forecast[Product]),Forecast[Mix %Measure])/100

I need to use another distinct measure in this for a column called (Forecast[Submission]).

This would mean the measure takes the average of each individual product as it already does but also for each individual submission period and averages these - can anyone help with how I add this second DISTINCT qualifier to the measure,

Many thanks if you can help!

 

[Matt Allington]

It is difficult to understand what you are asking here. Is Forecast[Mix %Measure] a measure or a column? If it is a measure, you should not specify the table name (see my post on best practices here http://exceleratorbi.com.au/best-practices-power-pivot-power-query-power-bi/)

then you say you need "another distinct measure". I assume you mean a distinct function over the stated column. So are you saying you want to iterate over each combination of product and submission in the forecast table? If so, try replacing
distinct(forecast[product]) with

all(forecast[product],forecast[submission])

 

[Grinch356]

Hi Matt,

You were correct - specifying the table name was causing my issues, thanks for the advice!