Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
When Using the ALL function to try and create a sum across categories I get an erroneous result.
This error has some odd behaviour:
-It only shows up when the underlying data is sparse
-It only shows up for some of the rows, even when they're within the filters excluded by ALL
-It's not present when using ALLSELECTED, despite not having any relevant external filters
-It dissapears when changing one table column from date to date-hierarchy
I have created a .PBIX with simplified data to illustrate the issue here: https://file.io/qRkApG5mevv7 https://drive.google.com/file/d/1uMZ20U52LhunlAu2ytR4tj4CEIiWlz08/view?usp=share_link
@DanHowland , there is no file at the given link
Power BI How ALL Works:
Apologies for the issue with the link, I've hosted the file again here: https://drive.google.com/file/d/1uMZ20U52LhunlAu2ytR4tj4CEIiWlz08/view?usp=share_link
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |