Getting Average and filtered summarize

[Anonymous]

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 filtered only by "confirm and unconfirm" like table below

2. Im willing to get average from % utilize , sometime result is OK , different month with more details result different than my excel . i did compare between powerbi and excel but result different , powerbi did different than excel .

below of table , showing average . will automaticaly changes when i click month (header of column)

Thanks

Syaiful

[v-gizhi-msft · Accepted solution]

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]

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