Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Measure get's filtered wrong

Hey guys,   I'm stuck on the following problem: I created few report pages, two pages are connected with a drill through. Now i created a measure, which should show me the total average of chemic...
Need Help
  • MFelix's avatar
    MFelix
    4 years ago

    Hi Anonymous ,

     

    Add the following measures to your model:

    Al Average = 
CALCULATE(AVERAGE('Table'[AL]), KEEPFILTERS('Table'[material] in VALUES('Table'[material])),all('Table'))

C Average = 
CALCULATE(AVERAGE('Table'[C]), KEEPFILTERS('Table'[material] in VALUES('Table'[material])),all('Table'))

Si Average = 
CALCULATE(AVERAGE('Table'[Si]), KEEPFILTERS('Table'[material] in VALUES('Table'[material])),all('Table'))

     

    Then use it on the drill trough:

     

MFelix's avatar
MFelix
Super User
4 years ago

Hi Anonymous ,

 

Add the following measures to your model:

Al Average = 
CALCULATE(AVERAGE('Table'[AL]), KEEPFILTERS('Table'[material] in VALUES('Table'[material])),all('Table'))

C Average = 
CALCULATE(AVERAGE('Table'[C]), KEEPFILTERS('Table'[material] in VALUES('Table'[material])),all('Table'))

Si Average = 
CALCULATE(AVERAGE('Table'[Si]), KEEPFILTERS('Table'[material] in VALUES('Table'[material])),all('Table'))

 

Then use it on the drill trough:

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    MFelix thanks for your help

    works perfect for me ğŸ˜ƒ