How to create a measure that cannot be filtered?

[rush]

Hi

I have 2 measures that represent the same information whereby I require 1 of the measures to remain static in my line graph to serve as the companies average?

I do not want to create 2 graphs then use the interactions panel to overcome this challenge.

Is this possible?

[MFelix]

Hi @rush,

Depending on your information and measures you may need to use the ALL or ALLSELECTED formula to filter you information on one of the measures,

Regards,

MFelix

[rush]

@MFelix
I am not sure how to amend those changes.

The measure below is calculating an average based on a column:

CALCULATE(AVERAGE(
	((Utilisation[UT (Exl. TO)])))
	

[MFelix · Accepted solution]

Hi @rush,

you should do something like this:

ccc =
CALCULATE (
    AVERAGE ( Utilisation[UT (Exl. TO)] ),
    ALL( Table[Company] )
)

Regards,

MFelix 

[rush]

@MFelix
Thanks, it works well.

I had a hierarchy created to be used in a filter which I had to add the columns needed below in my formula:

Measure = 

CALCULATE (
    AVERAGE ( Utilisation[UT (Exl. TO)] ),
    ALL( Billing_Info[Region],Billing_Info[Cluster],Billing_Info[Practice])