I want % Total contribution from different table revenue. ie

[arvindyadav]

Hi Team,

I want % Total contribution from different table revenue. ie,

please find a better image to understand my question.

[az38 · Accepted solution]

Hi again @arvindyadav 

do you have one row per day in Table2 ? try

Measure = divide(calculate(sum(Table1[Amount]));calculate(Sum(Table2[Amount]);FILTER(ALL(Table2);Table2[Date]=Selectedvalue(Table1[Date]))))

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

LinkedIn

[arvindyadav]

Hi @az38 Genius Man!

Thanks !