Duplicate Measure which have values in percentage from another measure

[krishak77]

Hello All,

It would be great if anyone help me on the below situation.

I have created a measure which has with percentage value and i am trying to get each second row to come in first row on the new measure with total value.

I am using below code and it is coming as 1 for each row, instead of second row value.

A_FR_SOTAT = VAR CurrentRow = 'SOTAT Analysis'[A_rownumber]

VAR PreviousRowVD = CALCULATE([A_CUM_FRSOTAT_Per], FILTER(ALLSELECTED('SOTAT Analysis'[Sotat]), 'SOTAT Analysis'[A_rownumber] = CurrentRow +1))

RETURN

PreviousRowVD

Thank you in advance.

Regards,

AK

[lbendlin]

row numbers are only meaningful in measures if they are displayed in the filter context.  As soon as you aggregate beyond them, the measures will fail.

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[krishak77]

Hello @lbendlin,

Can you please help to get solution.

I have uploaded the sample file on the below link.

https://docs.google.com/spreadsheets/d/1abWS7DNuLfuUs5-vBUoGj0J8Xz8ieeSoEfBj3R9HVuQ/edit?usp=drive_l...

based on Sheet "DATA Export", I have created the Pivot in New Sheet, on that sheet i have applied formula on the column D and E.

So i am tring this calculation in Power BI, but i am not getting result as per Column E in Power BI.

It would be really great if  i get correct Out put from Power BI.

On the below link can find the PBIX.file which i am trying to do.

https://drive.google.com/file/d/16cZXhGBGtjlc-rEZ_c3gBHtTuq2F2XQa/view?usp=sharing

Thank you in advance.

Regards,

AK

[lbendlin]

[krishak77]

Hi @lbendlin ,

Thanks for your response, I am already getting Cumulative percentage.

But i need to get last column"FR_SOTAT" next to Pivot table, which has below formula in excel file.

=IF(AND(D4<0.9,D5>=0.9),A4+(A5-A4)*(0.9-D4)/(D5-D4),0)

Row Labels	Count of Sotat	Count of Sotat2	SOTAT%	FR_SOTAT
0	8965	73.96%	73.96%	0
1	1035	8.54%	82.49%	0
2	860	7.09%	89.59%	2.076498
3	651	5.37%	94.96%	0
4	129	1.06%	96.02%	0
5	77	0.64%	96.66%	0
6	62	0.51%	97.17%	0
7	115	0.95%	98.12%	0
8	40	0.33%	98.45%	0
9	34	0.28%	98.73%	0
10	46	0.38%	99.11%	0
11	11	0.09%	99.20%	0
12	14	0.12%	99.32%	0
13	22	0.18%	99.50%	0
14	23	0.19%	99.69%	0
15	11	0.09%	99.78%	0
20	3	0.02%	99.80%	0
21	13	0.11%	99.91%	0
29	4	0.03%	99.94%	0
30	1	0.01%	99.95%	0
33	1	0.01%	99.96%	0
41	3	0.02%	99.98%	0
52	2	0.02%	100.00%	0
Grand Total	12122	100.00%	200.00%	0

is it possible to get this?

Thank you in advancec

Regards,

AK

[lbendlin · Accepted solution]

[krishak77]

Awesome @lbendlin thanks a lot, this is what i needed, really much appreciate your support.