Forum Discussion

Kimbornhoft's avatar
Kimbornhoft
Helper I
9 years ago

Incorrect calculated measure total

Hi,   I have a new measure    Total Shipped Value = (sum(REV_HistoryReport[Total Li Valu Amt]) /sum(REV_HistoryReport[Ord Bill Unit Qty]) * sum(OpenOrders[Qty Filled]))   which works correctly ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

I'm not totally sure which table we are talking about, but... errr, uhh... if we are talking about double rows in REV_HistoryReport,  maybe inside the CALCULATE  divide by COUNTROWS(REV_HistoryReport) ?

Kimbornhoft's avatar
Kimbornhoft
Helper I
9 years ago

I have used this string,

 

Total Shipped Value = SUMX(REV_HistoryReport, CALCULATE(sum(REV_HistoryReport[Total Li Valu Amt])/sum(REV_HistoryReport[Ord Bill Unit Qty]) * sum(OpenOrders[Qty Filled])))

 

but I'm not sure where to incorporate the count rows  Could you help with this?

 

 

  • Kimbornhoft's avatar
    Kimbornhoft
    Helper I
    9 years ago

    You were right in assuming it is the REV history report.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago
      Total Shipped Value =
      SUMX (
          REV_HistoryReport,
          CALCULATE (
              SUM ( REV_HistoryReport[Total Li Valu Amt] )
                  / SUM ( REV_HistoryReport[Ord Bill Unit Qty] )
                  * SUM ( OpenOrders[Qty Filled] )
                  / COUNTROWS(REV_HistoryReport)
          )
      )
      • Kimbornhoft's avatar
        Kimbornhoft
        Helper I
        9 years ago

        Unfortunately, formula still isn't returning the correct values. I'm not sure where to go next.