Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Report Builder Matrix Totals Incorrect

Hi,   I am trying to create a matrix in Report Builder that I have in Desktop. I copied the DAX query for the table and added it as a dataset in Report Builder.   Some of the columns rely on meas...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    To anyone else new to this all, i fixed it but it meant re-thinking my DB. You have to do these calcs IN report builder instead of relying on the measures to do your totals correctly (they won't).

     

    Instead i added new measures that gave SUM totals in dataset that were needed to perform the calculations in powerBI Report Builder. I then just applied formulas on those columns. Problem solved.

     

    So, just rethink your data when moving reports to Report Builder

Anonymous's avatar
Anonymous
Not applicable
3 years ago

To anyone else new to this all, i fixed it but it meant re-thinking my DB. You have to do these calcs IN report builder instead of relying on the measures to do your totals correctly (they won't).

 

Instead i added new measures that gave SUM totals in dataset that were needed to perform the calculations in powerBI Report Builder. I then just applied formulas on those columns. Problem solved.

 

So, just rethink your data when moving reports to Report Builder