Average %

[Anonymous]

I need to average the column CONFIABILIDAD [column calculadted: New Measure] (Picture 2) excluding the column META (Picture 1). The formula DAX (Picture 4) that I am using is averaging everything (it is not excluding the column META) and the "wrong" result is 81.83% (Picture 3). The correct answer should be 96.67%. I appreciate the help

[AnkitBI · Accepted solution]

Please try something like below, using filter to exclude product not required. 

Measure 7 = AVERAGEX(KEEPFILTERS(filter(values('Product'[Category]),'Product'[Category] <> "Bikes")),CALCULATE([Measure 5]))

Regards,

AJ

Do Like Post if response seems good and Worth liking.

Do Mark as Solution if response resolved your Issue.

[AnkitBI · Accepted solution]

Please try something like below, using filter to exclude product not required. 

Measure 7 = AVERAGEX(KEEPFILTERS(filter(values('Product'[Category]),'Product'[Category] <> "Bikes")),CALCULATE([Measure 5]))

Regards,

AJ

Do Like Post if response seems good and Worth liking.

Do Mark as Solution if response resolved your Issue.

[AnkitBI · Accepted solution]

Actaully, Didn't get time to add few things yesterday.

1) You don't need KeepFilters here. As per PBI Docs, KeepFilter is only required with Calculate and CalculateTable to keep context from changing.

KeepFilters

2) When using a Measure inside Aggregate function, you don't need to add Calculate function. Don't have an exact theory however as per my understanding, using Measure an internal/default Calculate is automatically added.

Regards
AJ

[Anonymous]

Thanks AnkitBI,
I did it without using KeepFilters and it worked perfectly. Very thankful

[Anonymous]

Thank AnkitBI,

Excellent!!