Forum Discussion

SidsDataAnalyst's avatar
SidsDataAnalyst
Regular Visitor
4 years ago

DAX Related

Hi all, I am trying to used measure to show the sales value per mobile number ,but it is showing the total amount only. Any help will be appreciated. Thanks in Advance     ...
Need Help
speedramps's avatar
speedramps
Super User
4 years ago

Sales values =
SUMX(
'Product delivered',
Product delivered[Quantity] * Product delivered[Price]
)

SidsDataAnalyst's avatar
SidsDataAnalyst
Regular Visitor
4 years ago

Thanks for the reply,

but still it's showing the total for each number

  • speedramps's avatar
    speedramps
    Super User
    4 years ago

    Hi again SidsDataAnalyst

    Try remove the auto summarise on the Product Delivered [Phone] and Product Delivered [Price] fields.

     

    Then add a new visual and drag the Product Delivered [Phone], Product Delivered [Quantity] and the 

    Sales values = SUMX('Product delivered', Product delivered[Quantity] * Product delivered[Price]

    Click here to see a demo 

     

    Remember we are BI community voluntrees so please click the thumbs-up for me taking the trouble to help you and then accept the solution if it works.  Thank you !