FIlter Values By Units | two tables

[Anonymous]

Guys, I have the table below that has the consumption values ​​of some units, ordered by date.

However, I have another table that gives me values ​​also ordered by only 3 columns of the first table, the Date, Customer and Profile. Dont have units.

In Excel I could find out how much percent each unit represents by doing the following below:

consumption Local 1 / SUMIFS(DATE;CUSTOMER;PROFILE)

How to do this in BI?

Thnks!

[rfigtree]

another way probably not as good.

if multiple dates you will need to modify to suit.

[wdx223_Daniel]

there are two methods to solve this

1) create a calculated column for each table to combine the 3 columns of DATE;CUSTOMER;PROFILE as a Key, then create a relationship between these tables. and use a measure to do this trick

%=divide(1,countrows(table2))

2) no need to create a relationship, directly use the measure like this

%=calculate(divide(1,countrows(table2)),treatas(summarize(table1, table1[DATE],table1[CUSTOMER],table1[PROFILE]),table2[DATE],table2[CUSTOMER],table2[PROFILE]))

[Anonymous]

Hi Daniel,

Thanks for the answer. I tried here, however, the results obtained at 100% for each unit, do not have the values ​​that each unit makes up in the profile., like my third image above.

I don't know if the questioning was well understood. But each unit has a weight within the profile.

[wdx223_Daniel · Accepted solution]

[Anonymous]

Dude, you're awesome! Thank you very much.