Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!!
Solved! Go to 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
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.
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
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
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.
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')
)
)
This is just returning 0's as the result
Can you share sample data and sample output.