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 ,

 

Quick summarization:

Or create a measure:

 

average measure = CALCULATE(AVERAGE('Tonnage Data Table'[TONNAGE CAP]),ALLEXCEPT('Tonnage Data Table','Tonnage Data Table'[Tonnage Vessel Name]))

 

 


Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.