The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I create a measure to calculate son Mrkup values, the proble is that when I add thi to a table the rows shows the correct value but the TOTAL remain as 0
I have negative values on this column, can that be the problem?
Here is the formula
MU$ Pending USD = IF(SUM(dlog0053ws[data.pagado]) = 0,IF(AND(SELECTEDVALUE(dlog0053ws[data.currency]) = "MXP", YEAR(SELECTEDVALUE(dlog0053ws[Order Date])) = 2022) = true, [MU$] / 20.25, IF(AND(SELECTEDVALUE(dlog0053ws[data.currency]) = "MXP", YEAR(SELECTEDVALUE(dlog0053ws[Order Date])) = 2021) = true, [MU$] / 20.47, [MU$])),0)
Hi, @Anonymous ;
You could add another measure to ajust the total. like below:
total =
SUMX (
SUMMARIZE (
'dlog0053ws',
[data.currency],
[Order Date],
[data.pagado],
"1", [MU$ Pending USD]
),
[1]
)
or can you share more columns screenshot associated with your DAX?
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.