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,
I am struggling with understanding why measures do not total correctly.
In this report , I am trying to perform the following calculation while keeping the filter context on the table.
IF the Invoice Age is equal to or less than 6, then calculate the reserve * Current Exchange rate otherwise 0.
LTTPEXCHANGE =
SUMX (
VALUES ( '000_BadDebt'[Document Number] ),IF([AGE] <=6,
MAX('000_BadDebt'[Reserve]) * MAX('00-Bad_Debt_MC'[XCHGRATE]),0))
Then I simply want to show the reserve needed: IF the document is <=6 then LTTPEXCHANGE else [Revalued NET Commision (USD)]
Reserve Needed = SUMX('000_BadDebt',IF(
[AGE] <=6,
[LTTPEXCHANGE],
[Revalued NET Commision (USD)]
))
However, the actual row to row calculation works just great, but the actual total does not.
How can I get the calculation to work?
Thank
Hi @lcasey,
What's wrong with the total?
Can you share a sample?
What does "the document is <=6" mean?
Best Regards,
Dale
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 |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |