Forum Discussion

jpoitras's avatar
jpoitras
Frequent Visitor
7 years ago
Solved

Help aggregating data from indirect table

New to Power BI Scraped the forums but haven't landed on an answer that worked for me.   I have 3 tables  - WorkStream: just an id  - WorkStreamCapacity: workStreamId, User, Capacity (number in ...
Need Help
  • jpoitras's avatar
    jpoitras
    7 years ago

    So I've solved my problem by normalizing some of my data further, but mainly by creating a measure using crossfilter which amounts to:
    In my WorkStreamCapacities table
    Allocation = CALCULATE(SUM(Tasks[Estimate]), CROSSFILTER(Tasks[WorkStreamId],WorkStream[id], both))

    Now I can show a person's estimated allocation against their available capacity sliced by work stream.

jpoitras's avatar
jpoitras
Frequent Visitor
7 years ago

So I've solved my problem by normalizing some of my data further, but mainly by creating a measure using crossfilter which amounts to:
In my WorkStreamCapacities table
Allocation = CALCULATE(SUM(Tasks[Estimate]), CROSSFILTER(Tasks[WorkStreamId],WorkStream[id], both))

Now I can show a person's estimated allocation against their available capacity sliced by work stream.