Forum Discussion

hackfifi's avatar
hackfifi
Helper V
5 years ago
Solved

Average Line in Column Chart not calculating

Good Day - I am strugging to get an STRAIGHT Average Line for a measure irrespective of the X axis. I have a measure which calculates the average correctly i.e. shown in the image/card as 2.03 When...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    5 years ago

    HI  hackfifi 

    Just add a IF conditional in formula as below:

    Avg PF = 
IF(NOT(VALUES(Projects[Project])) IN VALUES('Exclude Projects'[Project]), 
CALCULATE(AVERAGEX(Projects,[PF]),ALLSELECTED(Projects)))

    Result:

     

    Regards,

    Lin

hackfifi's avatar
hackfifi
Helper V
5 years ago

On more query, if i had ANOTHER TABLE "Exclude Projects" with data values as Project 1, Project 2, Project 3 etc which is NOT related to MASTER PROJECT TABLE, is possible to calculate the average excluding the selected projects from "Exclude Projects"

 

For example, if i select "Project 3" from "Exclude Projects" slicer, i would like the average line to show only average of Project 1 & Project 2.

 

Thanks mate!!

v-lili6-msft's avatar
v-lili6-msft
Community Support
5 years ago

HI  hackfifi 

Just add a IF conditional in formula as below:

Avg PF = 
IF(NOT(VALUES(Projects[Project])) IN VALUES('Exclude Projects'[Project]), 
CALCULATE(AVERAGEX(Projects,[PF]),ALLSELECTED(Projects)))

Result:

 

Regards,

Lin