Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Average based on multiple columns (categories)

Hi there, In SQL we can do  Create table A ( Company int null, Job int null, Phase int null, Units int null ) Insert into A (Company,Job,Phase,Units) Values (01,161705,16109,23), (01,161705...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Cherry,

    I solved it by adding Summarize table with two columns 1 = Group by Phase 2 = Average(Projected UnitHour)
    Then established relationship on Phase with bi directional and it works

    Thanks,
    Ed Dror

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous ,

For your requirement, please create the calculated column in Power BI with the formula below.

Column =
CALCULATE (
    AVERAGE ( Table1[Units] ),
    ALLEXCEPT ( Table1, 'Table1'[Company], 'Table1'[Phase] )
)

Here is your desired output.

Best Regards,

Cherry

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Cherry,

It Didn't work I tried AverageX, Calculate measure, yours solution but nothing seems to work

Basiclly (see attachment) I want to repeat the Average (Mean and Median) to all rows based on Phase value

The Total Mean at the bottom 8.29 to show on each and every row So I can do the chart looks like this

The filter based on Phase only not Copany Job Phase.

Thanks,

Oded Dror

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Cherry,

    I solved it by adding Summarize table with two columns 1 = Group by Phase 2 = Average(Projected UnitHour)
    Then established relationship on Phase with bi directional and it works

    Thanks,
    Ed Dror