Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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
Proud to be a Super User!
Paul on Linkedin.
Thanks a lot! for the help!
Best regards
thank you very much, but to be able to make a line chart that shows in % ?
that I need to replicate
Best regards
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
Proud to be a Super User!
Paul on Linkedin.
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
Proud to be a Super User!
Paul on Linkedin.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |