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.
Hi All
Can some one share with me how to remove them ?
Paul
Solved! Go to Solution.
Please change the formula to this one and it will bring the results you want.
Hi All
Above is my PBI file
Paul
The problem is that the sum calculation looks for rows with values = 0. You have rows for the same company which have -ve and +ve values (whose final sum is 0). These rows are not = 0, therefore they are included.
To remove these:
Create a measure for the sum of values:
SumAr = SUM(AR[A/R amount include GST in LC])
Now use this final measure in the visual:
SumAR (no 0 values) = IF(SUMX(Company, [SumAr]) >0, [SumAr])
Proud to be a Super User!
Paul on Linkedin.
Please change the formula to this one and it will bring the results you want.
Hi Themis
Thank you so much for sharing the expression work fine,
Paul
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |