Forum Discussion

JeffH's avatar
JeffH
Icon for Helper I rankHelper I
6 years ago
Solved

Help

Hello,    I have data given to me in the following format. Basically it is truckloads with mulistops on them. The data shows the load ID but has the total load cost on each stop row. I need to show...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    Does this work?

    =SUMX(VALUES(Data[CHRNumber]),[Load Cost])

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

Create a Table visual and drag Load ID to it.  Write these measures:

Load = MIN(Data[Total Load])

Count = COUNTROWS(Data)

Hope this helps.

  • JeffH's avatar
    JeffH
    Icon for Helper I rankHelper I
    6 years ago

    Thank You, that did the trick. However I should have mentioned that I need to be able to total my load costs. Using the MIN function just shows the MIN load cost rather than the totals. Is there a way to total this? 

     

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      6 years ago

      Hi,

      Does this work?

      =SUMX(VALUES(Data[CHRNumber]),[Load Cost])

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi JeffH,

       

      That is a new ask and you should start a new thread for this, 

      I believe the trick solved what you wanted in the initial post.