Table Stop Row Aggregation

[syncwithconnex]

Hi,

I am using the Power BI table. In my monthly fee column, the row is aggregated. Monthly fee is of type currency. I only want the aggregate to appear in the footer. Here is a screenshot. What am I doing wrong?

[syncwithconnex · Accepted solution]

The relationship of the table was incorrect. I was using the wrong fields. Once I made it a one to many, the query worked.

[Anonymous]

@syncwithconnex 

So you fixed your problem? But I guess you cannot used Related function if there is no relationship.

Paul

[amitchandak]

@syncwithconnex , you have to share the formula

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[syncwithconnex]

MonthlyFee comes from another table and there was no relationship between the two tables. I corrected the issue by creating a calculated column and using the RELATED DAX.