Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago
Solved

Help with adding amounts by category

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
  • PaulDBrown's avatar
    PaulDBrown
    3 years ago

    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