Earn 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
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |