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.
We are facing an issue in power bi dax query and please let me know if anyone come across or can help us on that.
Thanks in advance.
We have a dataset which has following values after filter selection,
Category Actual
------------------------------------------------
Paint & Liquid Material $24,399.12
Paint & Liquid Material $25,039.13
When we use the same dataset from dax query to form another dataset It is giving a wrong aggregation (sum).
Value it shows now is, $1,97,513.00
Sum of the above actual columns should be $49,378 ($24,339.12 + @25,039.13)
Without aggregation it shows values properly in dax as well.
Hi cthariharan,
Are there some duplicate values in [Actual] column? Could you please give the DAX formula or screenshot about your filter?
Regards,
Jimmy Tao
Check your filters. This is most likely a human error
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 |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |