Help with adding amounts by category

[Syndicate_Admin]

Hello

I need to help please to create a dax formula that adds the sales of my channel column:

I don't know if it's possible

of anteman

[Syndicate_Admin]

Thanks a lot! for the help!

Best regards

[Syndicate_Admin]

thank you very much, but to be able to make a line chart that shows in % ?

that I need to replicate

Best regards

[PaulDBrown · Accepted solution]

You need the following measure:

% por canal =
VAR _ALL = CALCULATE ([Measure Sum Deuda], ALL(fTable[Canal])

RETURN

DIVIDE([Measure Sum Deuda]), _ALL)

Format this measure as a % in the ribbon

then create the line chart using this measure and add fTable[Canal] as the legend

[PaulDBrown]

You can show the totals by "Canal" in any number of ways: for example using a simple SUM measure or using ALLEXCEPT as a filter in a measure:

Measure Sum Deuda = 
SUM(fTable[DEUDA TOTAL])

SUM ALLEXCEPT = 
CALCULATE([Measure Sum Deuda], ALLEXCEPT(fTable, fTable[Canal]))

I've attached the sample PBIX file