Forum Discussion
Table Stop Row Aggregation
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?
The relationship of the table was incorrect. I was using the wrong fields. Once I made it a one to many, the query worked.
4 Replies
The relationship of the table was incorrect. I was using the wrong fields. Once I made it a one to many, the query worked.
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.
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.
So you fixed your problem? But I guess you cannot used Related function if there is no relationship.
Paul
