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

[@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

[@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

[@jamesbarnett5236]

This was a great video. Super helpful l.

[@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

[@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

[@almenos15letras]

👌🏼

[@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]

kzbin.info/www/bejne/rZOsnJaId9GCl9E

[@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