Forum Discussion

rolf1994's avatar
rolf1994
Icon for Helper II rankHelper II
9 years ago
Solved

Calculated total showing the wrong number in directquery

Hi, I am trying to calculate the following:   Measure DistinctQuantity = CALCULATE(DISTINCTcount([Id]),[IsActive]="Active") Measure TotalPrice= DistinctQuantity*sum(Price) My data looks like th...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    rolf1994

     

    In this scenario, you TotalPrice should be eavaluated on each row level, so you should use SUMX() function.

     

    Total Price = SUMX(Table3,Table3[Price]*[Total Quantity])

     

     

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

rolf1994

 

In this scenario, you TotalPrice should be eavaluated on each row level, so you should use SUMX() function.

 

Total Price = SUMX(Table3,Table3[Price]*[Total Quantity])

 

 

Regards,