Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Average filtered by column from different table

I am very new to Power BI, so this may have a very easy solution, but I haven't been able to find it.   I have 2 tables, one with transactions data and another with yields (quarterly). They both ha...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    Anonymous ,

     

    Based on your description, I guess " the year average for yields" you meantioned is a measure to calculate average percentage each year, right? The issue should be caused that you use a column in another table as a X-axis and the measure you created as Y-axis. Please try calculate column instead of measure and check again.

     

    However, if this issue still persists, please share the sample data(e.g.: dummy data of the two tables) and the dax code of the measure.

     

    Community Support Team _ Jimmy Tao

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

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

Anonymous ,

 

Based on your description, I guess " the year average for yields" you meantioned is a measure to calculate average percentage each year, right? The issue should be caused that you use a column in another table as a X-axis and the measure you created as Y-axis. Please try calculate column instead of measure and check again.

 

However, if this issue still persists, please share the sample data(e.g.: dummy data of the two tables) and the dax code of the measure.

 

Community Support Team _ Jimmy Tao

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