Forum Discussion
Syndicate_Admin
3 years agoAdministrator
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
- 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
Syndicate_Admin
3 years agoAdministrator
thank you very much, but to be able to make a line chart that shows in % ?
that I need to replicate
Best regards
- PaulDBrown3 years agoCommunity Champion
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