Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I'm trying to create a DAX multiplication function and see the results row by row along with a column subtotal. However, The results do not always match expected. See example below.
I did a little research and I believe this is related to Row Iteration issues in Power BI.
Can someone please help me with the DAX and concept?
Extended Cost = vw_abc[Qty]*vw_abc[Unit Cost]
Many thanks,
Julie Bunavicz
I sincerely appreciate your help. I cannot share the file, but here's a mock screen shot and summary. I did a little research and played around so my orginal formula has changed. The goal is one column for Extended Cost with correct total row by row and column.
Below are two examples to demonstrate the issue. NOTE - There are no filters applied to the report
1. The "Extended Cost" measure calculates row by row correctly but results in the wrong column total.
Extended Cost = CALCULATE(SUM('vw_reciepts'[_ReceivedQty])) * SUM('vw_reciepts'[_UnitCost])
2. The "Extended Cost 2" custom column works for calculating column total but results in wrong row calculations at random.
Extended Cost 2 = CALCULATE(SUMX('vw_reciepts',vw_reciepts[Received Qty]*vw_reciepts[Unit Cost]))
Any ideas or suggestions?
Let me know if you have any questions.
Thanks,
Julie
I appriciate your help Ahmedx. Unfortunetly something still seems off. Any idea?
share the file so we understand what’s wrong with
pls try this
SUMX total price = SUMX('vw_abc','vw_abc[Qty]*vw_abc[Unit Cost])
User | Count |
---|---|
98 | |
91 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |