Showing results as a percentage of previous results

[JPrince_22]

Stage	% of cases
step 1	21
step 2	16
step 3	6
step 4	5
TOTAL	48

Hi

I have created a table visual in Power BI similar to the above which counts rows where a certain value appears. Each value is a step in a sequence, and i am trying to show the conversion rate from each step. 

The measure used to get the results is as follows:

Count of Step running total in Date = 
CALCULATE(
	COUNTA('stageTable'[Step]),
	FILTER(
		ALLSELECTED('StageTable'[Date]),
		ISONORAFTER('StageTable'[Date], MAX('StageTable'[Date]), DESC)
	)
)

I have been trying to use percentage of total, however the total is adding the results together. I would want therefore the total to be 21 in the example below, and to be able to display 100% instead of 21, with 76% in the second row and so on, but it is currently working out 21 as a % of 48. 

Help!! 

[JPrince_22 · Accepted solution]

Sorry the data is extremely complex and confidential so unable to share, but in the end i just hardcoded the total in each measure as this is a one off data request, so manged to get around the issue.

Thanks for the suggestions 

[v-juanli-msft]

Hi @JPrince_22 

Does the measure [Count of Step running total in Date] refer to the column [% of case] on your visual?

Could you show simple original data and expected result?

Best Regards

Maggie

[JPrince_22 · Accepted solution]

Sorry the data is extremely complex and confidential so unable to share, but in the end i just hardcoded the total in each measure as this is a one off data request, so manged to get around the issue.

Thanks for the suggestions 

[v-juanli-msft · Accepted solution]

Hi @JPrince_22 

If you want it to be dynamic, you could check my answers below:

dynamic total =
IF (
    HASONEVALUE ( Sheet3[Stage] ),
    [Count of Step running total in Date],
    CALCULATE (
        [Count of Step running total in Date],
        FILTER (
            ALLSELECTED ( Sheet3 ),
            Sheet3[Stage] = "step1"
        )
    )
)

Measure =
[dynamic total]
    / CALCULATE (
        [Count of Step running total in Date],
        FILTER (
            ALLSELECTED ( Sheet3 ),
            Sheet3[Stage] = "step1"
        )
    )

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Something like this

% = 
divide(
CALCULATE(
	COUNTA('stageTable'[Step]),
	FILTER(
		ALLSELECTED('StageTable'[Date]),
		ISONORAFTER('StageTable'[Date], MAX('StageTable'[Date]), DESC)
	)
),
CALCULATE(
	COUNTA('stageTable'[Step]),
		ALL('StageTable')
)
)

[JPrince_22]

This is just returning 0's as the result

[amitchandak]

Can you share sample data and sample output.