Forum Discussion
Solved
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 ...
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.