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

5 Replies

  • 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 !

         

         

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    4 years ago

    Please share your TotalQuantityDelivered measure.  The cell number column used in your visual does not appear to be filtering the table that measure is aggregating.

     

    Pat

     

  • Icey's avatar
    Icey
    Community Support
    4 years ago

    Hi SidsDataAnalyst ,

     

    Which table does the Phone column used come from?

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.