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,

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

In general, consider that the total line is really the measure evaluated in the context of ALL. You can add a if HASONEFILTER to your measure to calculate it for rows with the alternative being your calculation for your total row. I may have those reversed. It's early.