Daily trend for Percentage of Sales in a line graph

arafmustavi — Sun, 28 Apr 2024 06:03:40 GMT

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?

Re: Daily trend for Percentage of Sales in a line graph

AntrikshSharma — Sun, 28 Apr 2024 06:41:50 GMT

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