Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Getting Average and filtered summarize

Dear Team   I back again with another question i have a table of summary , view below : 1. GETTING SUMMARIZE with FILTERED STATUS what i want get from table above is, getting summariez but...
Need Help
Tips and Tricks
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    According to your description, I create a table to test:

    Then, I create two measures to calculate average of [UTILIZE] under different filters:

    Average-Original = AVERAGE('Table'[UTILIZE])

    Average = CALCULATE(AVERAGE('Table'[UTILIZE]),FILTER('Table','Table'[STATUS]="CONFIRM"||'Table'[STATUS]="UNCONFIRM"))

     

    And the result shows:

     

     

    Best Regards,

    Giotto Zhi

     

v-gizhi-msft's avatar
v-gizhi-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi,

 

According to your description, I create a table to test:

Then, I create two measures to calculate average of [UTILIZE] under different filters:

Average-Original = AVERAGE('Table'[UTILIZE])

Average = CALCULATE(AVERAGE('Table'[UTILIZE]),FILTER('Table','Table'[STATUS]="CONFIRM"||'Table'[STATUS]="UNCONFIRM"))

 

And the result shows:

 

 

Best Regards,

Giotto Zhi

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Dear GZ

     

    Thanks for response, specially for filtered summarize .

    but sorry for average not answering yet my question .

    i tried ur DAX but result not changing when i filtered on month . pls check picture below

     

    regards

    syaiful