cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mrothfusz Frequent Visitor
Frequent Visitor

Average Top15 minus the Top2

Hi,

 

I want to have an average from the values of the lowest Top15 minus the Top2 (so Nr3, 4, 5, etc till 15) of a column.

 

I’ve already got:

  

 

Output_ranking =
RANKX (
    ALLEXCEPT ( RAW, raw[AVG_VSIBASE] ),
    CALCULATE ( SUM ( RAW[Output] ) ),
    ,
    ASC
)

 

 

To rank the values

 

and

 

 

Output_IF = IF (
and (
raw[Output_ranking] <15,
raw[Output_ranking]>2),
"Y","N")

 

 

To determine Top3 until Top15

 

When I want to this:

 

 

Measure = CALCULATE (
              SUM(raw[Output]),
              raw[Output_IF]="Y"
              )

 

 I get some errors (see printscreen)

 

What's wrong? Smiley Frustrated

 

 

Thnx, Manfred

 

 

 

PowerBI_Error1.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Average Top15 minus the Top2

Hi @mrothfusz,

 

You can simply filter these records on visual level filter. For example:

 

Capture.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
2 REPLIES 2
Highlighted
Community Support Team
Community Support Team

Re: Average Top15 minus the Top2

Hi @mrothfusz,

 

You can simply filter these records on visual level filter. For example:

 

Capture.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
mrothfusz Frequent Visitor
Frequent Visitor

Re: Average Top15 minus the Top2

Yeah, totally forgot that Man Happy

 

Thnx