Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

SUMX wrong Subtotal

Hi all! I have a simple calculation of #Orders * Price. This data is displayed on a matrix visual with all articles. We receive a Subtotal for each department but it seems to be wrong. I tried th...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago
    Revenue = 

SUMX(VALUES('Master'[Article]), CALCULATE(COUNTROWS('Orders')) * [Price])
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago
Revenue = 

SUMX(VALUES('Master'[Article]), CALCULATE(COUNTROWS('Orders')) * [Price])