How to calculate PERCENTAGES based on a single column TOTAL in Power BI

[@badrkheiri7273]

I spent 2 hours looking for a solution for this case, navigating through many website, but you made my day, you are just amazing keep going and giving us ways to work out the problem thanks for this video

[@amsalespush]

Finally someone who explains this well. Thanks a lot.

[@NinaNoah-m1x]

Finally, a clear explanation, thanks

[@Transformita]

That’s the aim 👏✅ glad it helped

[@jamesbarnett5236]

This was a great video. Super helpful l.

[@Hassaan54321]

You can use following DAX measure to calculate percentage in single column that remove filter function .% of sales with Remove filter Function =
DIVIDE(sum('COUNTRYDEFAULTSUMMARIZATION'[SALES])
,CALCULATE('COUNTRYDEFAULTSUMMARIZATION'[Sum of Sales.],
REMOVEFILTERS()))

[@paraspadwal.0125]

worked very well

[@Transformita]

Glad it helped

[@subhashchoudhari4317]

we need that at Weekly or Monthly level?

[@Transformita]

Pbi will auto aggregate that the level you place in the visual.
If it’s weekly it’ll give the weekly breakdown 👍🏼

[@subhashchoudhari4317]

Done using allexcept function at Weekly level. actually Weekly was used in columns

[@almenos15letras]

👌🏼

[@vishnukrishnan3263]

Hello,
Is it possible to create a line chart inside 100% Stacked Column Chart Visual? If yes, request if you can please explain the process.
Regards

[@nssdesigns]

Is there a COUNTROWX that can SUM the rows regardless of a filter? As I need to calculate the percentage of a project that's split into 4 phases and the percentage is calculated on amount complete per phase divided by total in all four phases.

[@Transformita]

I’m assuming there’s a field for each phase. You want to use a matrix table and work out the % of work completed at each hierarchy.
I don’t have a video on this but I suspect this is the video you need:

[@Transformita]

th-cam.com/video/wbIkcRBlOao/w-d-xo.html