Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
arvindyadav
Post Partisan
Post Partisan

I want % Total contribution from different table revenue. ie

Hi Team,

 

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

please find a better image to understand my question.

 

Format1.PNG

1 ACCEPTED SOLUTION
az38
Community Champion
Community Champion

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


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

View solution in original post

2 REPLIES 2
az38
Community Champion
Community Champion

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


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

Hi @az38 Genius Man!

Thanks !

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.