Forum Discussion
Report builder measure issue
Hi, Peter_23
As you described, there are many duplications in expressions and measures. Since the total is added after loading the dataset into the report builder and then creating a new visual object, some expressions cannot be avoided.
I think this is because of two different products. At first, it was dedicated to paginated reports and served SQL Server Reporting Service. At that time, expressions were used, which was a long time ago. In recent years, it has developed into Power BI Report Server, which integrates Power BI's semantic model and other functions into it. This is also the current preview stage.
As recommended, complete the writing of measures in the semantic model as much as possible, and then present the data in Power BI Report Builder.
If you have already got the answer to the current problem in the previous reply, you can mark the corresponding reply as a solution so that other people in the community can quickly find help when they encounter similar problems.Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Peter_23
Thank you very much for clarifying this. To do this, I changed my expression as follows:
To be able to get the right results:
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks again Anonymous Yes, you can use expression instead of measure defined.
I understand it's not possible to use measure aggregation to total when the measure is division, standard deviation , etc, I should be rewrite the formule in expression. This way I have many measures and expression as same functions as many reports or report builders.
I figure out as good practice use defined measure in SM.
So I'm going to use expression.
Hi, Peter_23
As you described, there are many duplications in expressions and measures. Since the total is added after loading the dataset into the report builder and then creating a new visual object, some expressions cannot be avoided.
I think this is because of two different products. At first, it was dedicated to paginated reports and served SQL Server Reporting Service. At that time, expressions were used, which was a long time ago. In recent years, it has developed into Power BI Report Server, which integrates Power BI's semantic model and other functions into it. This is also the current preview stage.
As recommended, complete the writing of measures in the semantic model as much as possible, and then present the data in Power BI Report Builder.
If you have already got the answer to the current problem in the previous reply, you can mark the corresponding reply as a solution so that other people in the community can quickly find help when they encounter similar problems.Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous I don't know "This is also the current preview stage", ok I understand.
Thank you so much!