Daily trend for Percentage of Sales in a line graph

[arafmustavi]

I have a Datasaet that has daily sales data with category.

The Datatable sample

Date | Category | Sales Value
01-APR-24 | G1 | 100

01-APR-24 | G1 | 120

01-APR-24 | G2 | 150

01-APR-24 | G3 | 250

02-APR-24 | G1 | 120

02-APR-24 | G2 | 130

02-APR-24 | G3 | 150

The line graph should show daily percentage of sales by each category

Example

Date | Category | Sales Value
01-APR-24 | G1 | (220/620)

01-APR-24 | G2 | (150/620)

01-APR-24 | G3 | (250/620)

How should I design my DAX for this?

[AntrikshSharma · Accepted solution]

@arafmustavi 

% Of Total Sales = 
DIVIDE ( 
    SUM ( 'Table'[Sales Value] ),
    CALCULATE ( 
        SUM ( 'Table'[Sales Value] ),
        REMOVEFILTERS ( 'Table' )
    )
)