Forum Discussion

hackfifi's avatar
hackfifi
Helper V
5 years ago
Solved

Calculating Average excluding MEASURE data

  Hello - Trying to develop a measure excluding certain data.       Project PF Avg PF Exclude? Project 1 2.47 2.20 1 Project 2 1.54 2.20   Project 3 2.59 2.20     Cu...
Need Help
  • stevedep's avatar
    stevedep
    5 years ago

    Hi,

    Like this?

    ___AvgforNonExcluded = CALCULATE(
                            AVERAGE('Table'[PF]), FILTER(ALL('Table'),'Table'[Exclude]=BLANK()))

    As seen here:

    Link to file. 

    Please mark as solution if so. Thumbs up for the effort are appreciated.

    Kind regards, 
    Steve. 

  • Fowmy's avatar
    Fowmy
    5 years ago

    hackfifi 

    I forgot to remove the variable, as it always stays static, please check now:

    Avg PF (Excluded) = 
AVERAGEX(
    FILTER(ALL(Table2[Project]),[Exclude] <> 1),
    [PF]
)

    ________________________

    If my answer was helpful, please consider Accept it as the solution to help the other members find it

    Click on the Thumbs-Up icon if you like this reply 🙂

    YouTube  LinkedIn

     



     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

Does this measure work?  Drag this measure to a card visual.

=averagex(filter(values(data[project]),data[exclude?]<>1),[pf])

Hope this helps.