Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.