Report specific pivot filter within power pivot measure

[inascargio]

Hi all,

I need to report within a power pivot measure the pivot filter referring to a MAX measure.

See below example: I need to have the manager code (pivot field) generating the max sales (measure), reported in the measure called "winning manager code".

Any help on this is appreciated.

Thank you

inascargio

[some_bih · Accepted solution]

Hi @inascargio as shown on my picture, maybe you did see it, to see best manager code for each area in your pivot table insert area column and you should get my picture. try and check results

[some_bih]

Hi @inascargio  Best Manager measure could be 

Best Manager= TOPN(1;
ALL(Table1[manager code]);
[M_sales])

Adjust Table1 to your table name. Measure M_sales = sum(Table1[Sales]) (simple sum)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[inascargio]

Hi,

I tried the proposed solution but I get the same best manager code across all the areas i.e. manager code 555 who is the one with the highest overall sales.

How can I get the best manager code for each area?

Thank you again

inascargio