Forum Discussion

JeffH's avatar
JeffH
Helper 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
Super 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
Helper 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
    Super 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.