Forum Discussion

rush's avatar
rush
Icon for Helper V rankHelper V
8 years ago
Solved

How to create a measure that cannot be filtered?

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?

 

 

Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi rush,

     

    you should do something like this:

     

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

    Regards,

    MFelix 

4 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    8 years ago

    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's avatar
      rush
      Icon for Helper V rankHelper V
      8 years ago

      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's avatar
        MFelix
        Icon for Super User rankSuper User
        8 years ago

        Hi rush,

         

        you should do something like this:

         

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

        Regards,

        MFelix