Forum Discussion
Member Budget Contribution
Hi Community,
I have a table with Budget on Company granularity. Each Company has multiple members consisting of work hours for that company.
I made a measure to calculate member contribution to the Budget Time of the company which simply finds total member time and compares on Total Budget by individual time.
The result is perfectly-finds member contribution to the total budget of company.
But however when Member filter is applied It can't show member budget contribution as the Budget is not in member granularity .
How Can I achieve showing member contribution when user filters by member ?
Here is my pbix file: https://netlinkgroup-my.sharepoint.com/:u:/g/personal/schoden_netlinkgroup_com_au/EWqOXLftsMhFq7iMOdUcDcEBzIcIgSh73r5iVPcuO7fyhg?e=RIWzHY
Thanks in advance:D
schoden , try a new column
New column =
var _bud = sumx(filter(Table, [Company] = earlier([Company])), [Budget])
var _time = sumx(filter(Table, [Company] = earlier([Company])), [time])
return
[time]*_bud /_timeor a new measure
New column =
var _bud = sumx(filter(all(Table), [Company] = max([Company])), [Budget])
var _time = sumx(filter(all(Table), [Company] = max([Company])), [time])
return
sum(Table[time])*_bud /_time
2 Replies
schoden , try a new column
New column =
var _bud = sumx(filter(Table, [Company] = earlier([Company])), [Budget])
var _time = sumx(filter(Table, [Company] = earlier([Company])), [time])
return
[time]*_bud /_timeor a new measure
New column =
var _bud = sumx(filter(all(Table), [Company] = max([Company])), [Budget])
var _time = sumx(filter(all(Table), [Company] = max([Company])), [time])
return
sum(Table[time])*_bud /_timeyeahhhh It worked amitchandak Million thanks 😄
