Percentage for Rows

[SanderAzubi]

Hey Everyone,

i want to Display the Percentage in relation to the upper two Rows. 

The first two Rows should show "100%"

The following 4 Rows should show the proportion to the 100%

In the last Row should be the "+" or "-" Percentage which is left of the upper 100%

can someone help me? 

[v-xuding-msft · Accepted solution]

Hi @SanderAzubi ,

I created a sample to implement it. You could try the following steps.

1.Create a index column in Query Editor

2. Create a measure and then set it to percent 

Measure = IF(MAX('Table'[Index])<=2, 1,DIVIDE(SUM('Table'[Value]),CALCULATE(SUM('Table'[Value]),ALLSELECTED('Table'))))

For the last row, it is the total row. We can't show "+\-". It is show the first row value in my sample. And  I attached it that you can download.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SanderAzubi]

Thank you, it would have helped if i explained it better. I got more Data than those 6 Rows. I just Drill through them. If i´ve had those 6 Rows it would have worked. I still did it on my own. Thank you