Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

New Calculated Column With Grouping

Hi,   Here is my data, with the column I'd like to create. I want a column that divides B by C, but when the ID is the same, returns the average of all those calculations for that partic...
Need Help
  • Omega's avatar
    Omega
    7 years ago

    I created % measure using the below formula: 

     

    Average (B,C) = SUM(Table1[B])/SUM(Table1[C])

    For the new measure, try using the below formula: 

     

    New Measure = SUMX(ALLEXCEPT(Table1,Table1[ID]),[Average (B,C)])/CALCULATE(COUNTROWS(Table1),ALLEXCEPT(Table1,Table1[ID]))
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Not sure what you mean. There's no currency involved. This is my fact table. ID and A both connect to dimensions.

When you say B column will be a measure, do you mean creating a column or creating a measure? Aren't those different things?

 

I couldn't get your steps to work.

themistoklis's avatar
themistoklis
Community Champion
7 years ago

Anonymous

 

Sorry i thought A was a currency field.

 

Yes i meant create a measure based on Column B and also based on Column C.

Then another measure as described on step 4.

 

Finally on the table put ID, and then the 3 measures above