Forum Discussion
EKI
1 year agoNew Member
Dax formula
Dear all, I'm new to the Power BI environment so be patient with me. I have created a report for my project financial overview. I have a matrix table where the rows are the project hierarchy (m...
Anonymous
1 year agoNot applicable
Hi EKI ,
Do you mean that the total of the measure column is incorrect? I recommend you create another measure with SUMX function and use it in matrix. The measure column with the correct total should then appear, you just need to hide the original measure column.
Measure = SUMX('Table',[Unbilled amount])
If I'm not understanding the problem correctly, please provide more information such as sample data, dax of measure or link of pbix file.
Best regards,
Mengmeng Li