Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Difference between total of two sub-groups from a ... - Microsoft Power BI Community
Dear all,
We wanted to have a solution for getting Check value by tallying the Totals of Two sub-groups named Total Assets and Total Liabilities & Equity. Please refer the below screenshot for your understanding.
In our matrix, we are obtaining the Total Assets value and Total Liabilities & Equity values correctly. But, there is another Total that sums all the previous subgroup totals automatically.
Say for instance,
Assets:
Total = 1600
Liabilities & Equity:
Total = 1600
Total = 3200
Instead of 3600, We wanted to have a difference value, 1600-1600 = 0. We are keep trying, but failing to do. Could anyone pleas help us to achieve the expected results?
Thanks
Smita
You may use HASONEVALUE Function and IF Function.
https://community.powerbi.com/t5/Desktop/Incorrect-Measure-Total/td-p/472672
Hello,
Will you please explain more. I'm still not able to achieve it. How should I check Subgroup(Assets) total - Subgroup( Liabilities) total=0
Thanks
Smita
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |