Forum Discussion
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...
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.
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. When I am using the measures I have created in Power Pivot, I get the average of the entite column instead of corresponding tonnage capacity against each vessel name on dropping the measure in values section
Hi Anonymous
I can't get what is the relationship between your tables, and how your results came out like the screenshot. Can you provide a sample file? Will pm you my email address.