Forum Discussion
Report specific pivot filter within power pivot measure
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
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
3 Replies
- some_bih
Community Champion
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.
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
- some_bih
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
