cancel
Showing results for 
Search instead for 
Did you mean: 
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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.