MAX in DAX

[jamtay317]

Hello and thank you for taking the time to read this. It seams that I have stumbled Across a problem. I had a PowerPivot Table that in the row field has Sales Rep on top and Date on the bottom. In the values Field I have the count of Sales, so that when I open that rep it gives me a list of dates that have the count of sales for that Date. thats Great!
Now what I would like is next to the name when the drop is open or closed I would like to show the max sales for that person . in the date. all help is welcome.

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/powerpivot-questions/761474-max-dax.html#post3734754

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: Forum Rules).