cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

## % of values that are less than the average

Hi everyone,

Theres kind of complicated scenario. This is my test dataset.

Target : Find % of values that are les than average selected. (User can filter with category and average have to be recalculate)

So I make some calculations and have this.

Trying to achieve the target i created two measures. the first one calculate the average over all selected values and the second one i try to make a flag when the value was less than average.

```Average = CALCULATE(
[Total]/[Qty]
,ALLSELECTED(Test)
)```
`Flag = IF([Total]< [Average],0,1)`

Doing the maths on my excel this is what I have to get.

What we need is calculate "% of values are less than avg". I was thinking about sum flag when is 1 and then divide over total count but when I tried to sum flag value it resolve as 1.  Do you have an idea how to accomplish this? Maybe with a different way

PBIX attached

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: % of values that are less than the average

@jpereztang

Hi, use a measure

SumFlag = SUMX(Test,IF([Flag]=1,1,0))

And

% of Values are less than average = DIVIDE([SumFlag],[Qty])

Regards

Victor

Lima - Peru

Lima - Peru

Proud to be a Datanaut!

2 REPLIES 2
Super User

## Re: % of values that are less than the average

@jpereztang

Hi, use a measure

SumFlag = SUMX(Test,IF([Flag]=1,1,0))

And

% of Values are less than average = DIVIDE([SumFlag],[Qty])

Regards

Victor

Lima - Peru

Lima - Peru

Proud to be a Datanaut!

Regular Visitor

## Re: % of values that are less than the average

Eso fue la cereza del pastel, gracias @Vvelarde !

Saludos,