DAX Related

[SidsDataAnalyst]

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

[Icey]

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.

[mahoneypat]

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

[speedramps]

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

[SidsDataAnalyst]

Thanks for the reply,

but still it's showing the total for each number

[speedramps]

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 !