Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have a problem calculating totals in matrix.
There is 1 table history with all movements +/- of articles with a purchase price. I only need the last purchase price multiplied by the total + or - of the correct item.
This will work. I am getting the correct amount of quantity in stock * last purchase price via DAX
These articles are linked to a group, but I can no longer make a total sum per group of articles. The Group total is not correct. When Single item (1 article) is present in the group, the total of the group is correct calculated.
The grand total is also not correct calculated
DAX:
_arttot:
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
18 | |
15 | |
11 | |
11 | |
8 |
User | Count |
---|---|
24 | |
18 | |
12 | |
11 | |
10 |