cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper V

## How to calculate accumulated percentage

Hi

How do you calculate accumulated percentage when time is not involved?
It should accumulate per Logon name.

Best regards
Lotte

4 REPLIES 4
Community Support

@Dangar332 nice method! Thank you, for your quick response and the solution provided.
I am not sure how your semantic model looks like, but based on the sample and description you provided, I tried to create some dummy data.

``````% of Total =
VAR Total_View = COUNTROWS(ALL('Table'))
RETURN
[Report Views] / Total_View``````
``````Accum % =
VAR Total_View = COUNTROWS(ALL('Table'))
RETURN
CALCULATE (
DIVIDE ( SUMX(VALUES('Table'[Login name]),[Report Views]), Total_View ),
FILTER (
)
)
``````

Result is as below.

Best Regards,
Yulia Yan

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

Helper V

Thank you, @v-weiyan1-msft

Your calculation is not giving me the correct result, maybe it's because the visual is order by Report views and not Logon name.
But this calulation (almost) works:

``````Accum % Logons =
IF( ISINSCOPE( FT_PBI_ActivityLog[Logon name] ),
VAR CurrentRank =
[Report View Rank By Logon]
VAR RankAndViews =
ALLSELECTED(FT_PBI_ActivityLog[Logon name]),
"@Ranking", [Report View Rank By Logon],
"@Views", [Report Views]
)
VAR MoreViews =
FILTER(RankAndViews,
[@Ranking] <= CurrentRank
)
VAR Result =
SUMX(MoreViews, [@Views])
RETURN DIVIDE(Result,CALCULATE(COUNT(FT_PBI_ActivityLog[ReportName]),REMOVEFILTERS(FT_PBI_ActivityLog[Logon name])))
)``````

Except when 2 or more Logon name have the same no of Report views

BR

Lotte

Super User

Hi, @LotteLaugesen

if time is not present for comparing purpose then use below method it might work
make a new column

``````Column 2 =
var a = sumx(FILTER(ALL('Table'),'Table'[view]>EARLIER('Table'[view])),'Table'[view])
var b = 'Table'[view]+a
var c = SUM('Table'[view])
return
b/c``````

and don't forgot to change  column type to percantage

Helper V

Hi @Dangar332

Thanks for your answer, but 'Report Views' is a measure not a columnn in the table.
The table is not summarized, but has 1 record per view.

Report Views = COUNT(FT_PBI_ActivityLog[ReportName])

Do you have any other ideas?

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors