Forum Discussion

Frequent Visitor

9 years ago

Solved

Sort by another column error

Hi, I've created a cluster chart to display companies and the number of activities that our sales force have logged against them (Emails, calls etc). I would like to sort the data by the pipelin...

Need Help

v-ljerr-msft

9 years ago

Hi eyeball,

My mistake! Please try the formula below.:smileylol:

MaxPipeline =
VAR currentCompany = 'Table1'[company]
RETURN
    CALCULATE (
        MAX ( 'Table1'[pipeline] ),
        FILTER ( ALL ( Table1 ), 'Table1'[company] = currentCompany )
    )

Regards

v-ljerr-msft

Microsoft Employee

9 years ago

Hi eyeball,

Yes, the solution requires the company names to be unique to work correctly. If not, using companyId which is truly unique is needed.:smileyhappy:

Regards