How to make Contribution expression dynamic ?

[Paulyeo11]

Hi All

Below script is working fine , But the expression need to enter COMPANY field. it there a way to make it flexiable ? so that can be use for all field .

Contribution = 100 * DIVIDE(SUM('Table'[Sales]), CALCULATE(SUM('Table'[Sales]), ALL('Table'[COMPANY])))

[amitchandak]

@Paulyeo11 , not very clear , but try allselected

Contribution = 100 * DIVIDE(SUM('Table'[Sales]), CALCULATE(SUM('Table'[Sales]), ALLSELECTED('Table')))

also no need *100 (100*) as you can mark it as % column

[Paulyeo11]

Hi Amit

I have try allselected , got syntax error

[amitchandak · Accepted solution]

@Paulyeo11 ,

Contribution = 100 * DIVIDE(SUM('Table'[Sales]), CALCULATE(SUM('Table'[Sales]), ALLSELECTED('Table'[COMPANY])))
Contribution = 100 * DIVIDE(SUM('Table'[Sales]), CALCULATE(SUM('Table'[Sales]), ALLSELECTED('Table')))