Calculate net price and revenue with measue

[TomBrilliant]

I am trying to calculate the revenue with a few measures:

net price = (1-discount)*SUMX(Article, Article[gross price])

quantity = SUMX('pricelistline', pricelistline[quantity])

revenue = quantity * net price

I understand that the total revenue is the sum of quantity * sum of net price, but this gives me wrong total revenue. What sould I change? Net price does not need to be summarized.

[v-shex-msft]

Hi @TomBrilliant ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[some_bih]

Hi @TomBrilliant without your model it is hard to spot issue and propose some possible solutions.

Still, it seems that it could be (one possible solution) that you need to "create" net price as calculated column in your SAME table  as quantity. After that, simple SUMX (<same table>, net price*quantity) 

Another solution is related to RELATED function to "bring" data on same row.

Go to your model and think how to connect your inputs

[TomBrilliant]

Hi! thank you for your reply. This is hard because the value of the gross price and the quantiy both origin of another tables. I have a feeling it can be solved with measures, but I don't know how.

[some_bih]

Hi @TomBrilliant it could be...

Share simple file with ecpected output (office 365, dropbox ...links)