Forum Discussion
Measure with Divide from a dataset
You need to regenerate the formula at the Reporting Builder Table/Matrix. Because it is not a good practrice to SUM or AVG or any other aggregation to the measures that are returning Percentages or ratios.
In power bi desktop the measure calculating on run time. But in report builder you have all your dataset comes first and then it render in the report. That means that if you have discount percentages at product Level. It will not return you discount percentages at Product Category level as your dataset contains further granular data in the dataset. So it is best to return Values in the dataset and recreate percentage or ratios formula at Report Builder cell level thats where you will get the correct results.
I hope I have clarifed to you.
Community ChampionYou need to regenerate the formula at the Reporting Builder Table/Matrix. Because it is not a good practrice to SUM or AVG or any other aggregation to the measures that are returning Percentages or ratios.
In power bi desktop the measure calculating on run time. But in report builder you have all your dataset comes first and then it render in the report. That means that if you have discount percentages at product Level. It will not return you discount percentages at Product Category level as your dataset contains further granular data in the dataset. So it is best to return Values in the dataset and recreate percentage or ratios formula at Report Builder cell level thats where you will get the correct results.
I hope I have clarifed to you.