Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
For a number of report and figure I have a requirement to have 2 different "Total" lines, first one shows increase between current year and previous year, while the other one shows increase in percentage.
To show difference I have used ISINSCOPE function to create a custom total field, but I can only do one type of total not both at the same time. Is there any mechanism to achieve it?
Sample:
Solved! Go to Solution.
Hi @VladyOselsky
Unfortunately, we don't have some generic way to create multiple total rows.
There are some workarounds of alternatives.
Please refer to the discussion :
https://community.fabric.microsoft.com/t5/Desktop/Multiple-totals-on-matrix/m-p/734706
and tutorials of @parry2k
https://www.youtube.com/watch?v=gNLIaBMXr40&t=5s
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @VladyOselsky
Unfortunately, we don't have some generic way to create multiple total rows.
There are some workarounds of alternatives.
Please refer to the discussion :
https://community.fabric.microsoft.com/t5/Desktop/Multiple-totals-on-matrix/m-p/734706
and tutorials of @parry2k
https://www.youtube.com/watch?v=gNLIaBMXr40&t=5s
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly