Forum Discussion
Error in PowerBi Measure
Hi, I am new to PowerBI, however I have found this weird behavior in just a few of my calculated values which gives me wrong total value. I have a measure called Royalty Amount based on thi...
Go to your 'InvoiceData' table and filter just to one of the customers that is giving the unexpected result. My bet is, there are one or more lines where the Royalty Rate is something other than 0.0475.
Your SUMX is the same as adding a calcualted column to the 'InvoiceData' of 'InvoiceData'[Royalty Sales] * 'InvoiceData'[Royalty Rate] then putting a SUM over that calculated column.
I followed your advise and filtered for that one customer but all Royalty Rates for that specific customer, the invoices, and the highlighted products show 0.0475. 😞