2 Problems with the total row of a power bi table visualization

[javitxin42]

Hello, how are you doing?

I have a report that dynamically connects to the cube and BBDD so in power bi I only have the report view. I can't create measures, no columns or anything. I do all that on .net, in the cube itself.

Well, I have two problems.

The first is that, in the cube I have a calculated measure that needs three other measurements. The calculation does so but the total that appears in power bi, since it is a table, does not fit the one it should. Imagine that I have a measure in the cube with a value of 8 and I want to calculate the cube of that value (measure*measure*measure). Cube 8 is 512. That does well but the column total NO. I understand it's because it crosses values from 3 sites and goes crazy but I need to make a calculation from 3 measures and I don't know how to do it. I've set the example of a value cube because I find it easy to reproduce.

On the other hand I have a second issue and it is that I also have a column that shows the percentage of something. Imagine that I have 9 rows and each one has a percentage of 11.1... the total you show me is 99.9 and not 100%. How can I get him to show me 100% and not 99.9%. Rounding that total would be ideal but I remember I don't have the ability to manipulate at the power bi level. Everything I have to do in .net being a dynamic connection.

I hope you can help me with these two issues. If you need any more information, please tell me.

Greetings and thanks in advance.

Javier

[v-lili6-msft]

hi @javitxin42 

1. This sounds like a measure totals problem. Very common. See this post about it
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

2. I think you need to do it in cube, use HASONEVALUE Function to create a conditional measure as below:

Measure=IF(HASONEVALUE([Category]), <expression>,ROUND(<expression>,0))

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

Regards,

Lin

[javitxin42]

Hello, thank you for the answer.

The issue of calculating (measure*measure*measure) and not being considered well in the total is probably by the data model so I will put it in another post so as not to brown and mix things.

The total sum of percentages, I'm afraid that being my connection to the dynamic type cube I can only see power bi with the report view and I can not use DAX. Everything I have to do in visual studio .net.

I don't know what the solution might be for the total of a column to fit 100% and not 99.9%

In case my explanation is not clear, the point is that I have 9 columns with a value of 11.1 and clearly the total of that column that the table shows me (In the report view) is 99.9 and not 100. I'd like you to round me up or something.

Please, if I haven't explained myself right, tell me. Thank you and greetings!