how to find % contribution daily basis on account level in power bi

[arvindyadav]

Hi Team,

I have 15days stats with me. I know how to find % contribution on daily basis. But I want % contribution based on daily total on a vertical basis.

Here If you see in the image I have 8 vertical so I want how much % contribution made by each vertical in a particular day.

Suppose on the date of 14th Dec vertical -Health made 20720.75 and the total revenue of that day is 43979.02 then the formula is 20720.75/43979.02 = 0.47115 i.e, % contribution is 47.11%

Thanks,

Arvind

[az38 · Accepted solution]

hi @arvindyadav 

a simple measure isnt ok for you?

Measure = divide(calculate(sum(Query[Amount]));calculate(Sum(Query[Amount]);ALLEXCEPT(Query;Query[Date])))

do not hesitate to give a kudo to useful posts and mark solutions as solution

[arvindyadav]

Hi @az38 ,

Suppose the same case but I want % Total contribution from different table revenue. ie,

please find better image to understand my question.

Thanks,

Arvind

[arvindyadav]

Ohh I forget to allexcept in my measure. thank you @az38  🙂