SUMX result in power pivot

A dedicated forum to help people when working through the book "Learn to Write DAX"
Dibritti
Posts: 1
Joined: Fri Nov 22, 2019 10:30 am

SUMX result in power pivot

Postby Dibritti » Fri Nov 22, 2019 10:50 am

Hello,

I´m very new in dax, so I please call for your help and patience,

I have an issue to wright the SUMX formula in Power pivot,

I can't get the formula to give me a simple result of multiplying the column X with column Y
This is my formula:

=SUMX(Base;Base[Price]*Base[Quantidade])

the result is wrong and it repeats (same result) in every rows in the table and the data in each row is different
ex: of result:
Column base[price] = 1200
column base[quantidade] = 12
result column = 2228924522,89161

Can you please help ?

Best regards,

Return to “Help with the Book "Learn to Write DAX"”

Who is online

Users browsing this forum: No registered users and 0 guests

cron