Compute YTD Sales Contribution

[Paulyeo11]

Hi All

Below Script working fine :-

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

I convert the above script to below  , because i need to know YTD Sales contribution :-

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

Above does not work .

My PBI file :-

https://www.dropbox.com/s/8m8iw0nytj2jht8/8020%20V003.pbix?dl=0

Paul

[amitchandak · Accepted solution]

Try like. File attached after signature

YTD Sales Cont % = DIVIDE([YTD Sales],CALCULATE([YTD Sales],ALLSELECTED('Table')))