Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

AVERAGE BY CATEGORY

v-xjiin-msft  Anonymous Zubair_Muhammad  I need help with DAX to create a measure   I have a table with Vessel name and Tonnage Capacity   Vessel Name Tonnage Capacity Vessel ABC 0 Ve...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous 

     

    It was solved, Anonymous sent me files. It was an Excel connected to PBI dataset, using fact table column to retrieve data from dim table.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous 

 

I am not very sure what you want to achieve...your table only has 2 columns, and you want to select a Vessel Name in a slicer? to return an avg on Capacity of the same table? I saw there is another table Trips Data Table, what is in there? what is the relationship between these two tables?

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello Anonymous 

 

I am using Power Pivot in excel for my final analysis

 

Yes, I have 2 set of excel workbooks, Trips data table(Contains columns like Tonnage , Revenue) and Tonnage data table Contains columns like Vessel name and Tonnage Capacity

 

I need to create  a measure which will give me the tonnage capacity of every vessel when I drop the same in power pivot. However I am unable to create such measure.