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.
Hello All,
I have created a simple measure to calculate margin value (Total sales - total cost). However, for a few lines, it gives weird results.
An example is below in blue that my Dax measure produces with the expected outcome in green.
Solved! Go to Solution.
Hi @AbbasG ,
Does your data contain data with the same column and different values:
When placed on a Visual, the same [Model] is aggregated together.
If you use the Max() function in your Measure, the maximum value of each [Model] will be taken, not the total aggregate value.
You can use the Sum() function to get the aggregate value:
Sum_Measure =
SUM('Table'[Value1]) - SUM('Table'[Value2])
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @AbbasG ,
Does your data contain data with the same column and different values:
When placed on a Visual, the same [Model] is aggregated together.
If you use the Max() function in your Measure, the maximum value of each [Model] will be taken, not the total aggregate value.
You can use the Sum() function to get the aggregate value:
Sum_Measure =
SUM('Table'[Value1]) - SUM('Table'[Value2])
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
I have added new column with simple DAX you have mentioned above and it is giving correct result. Plz refer screenshot given below. If still you are facing same issue please check if you have applied any filter to grid or not.
Thanks.
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 |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |