Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Need help: average

Hi,    I calculated the amount of items rejected with the following dax:  Afgekeurde flowpacks = COUNTX(Espera; Espera[Index]) This value is filtered with a date filter on the page.   I would ...
Need Help
gipiluso's avatar
gipiluso
Icon for Resolver II rankResolver II
7 years ago

It should help somethink like:


Measure:=
CALCULATE(Afgekeurde flowpacks,FILTER(Date,Date[Calendar Date]>=DATEADD ( 'Date'[Calendar Date], -2, MONTH )))

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi gipiluso,

     

    I used your formula and it gave me the following result.

     

     

     

     

    I believe we must modify it in a way that it calculates the average 'afgekeurde flowpacks' per line over a period of 2 months.

     

    Any clue how? 

     

    • gipiluso's avatar
      gipiluso
      Icon for Resolver II rankResolver II
      7 years ago

      I think that the current measure perform the calculation on the 2 month before, in the report you should se the average of the 2 month collapsed in each point.