Forum Discussion
Solved
Get average using Main Category column only but also include subcategories in the table.
I have data of this data of thre column and I want output as Avg by Column. How to achive it?
The main problem is all three columns are from different tables but I have joined them.
| Country | state | population | Avg by Country |
| India | punjab | 2000 | 4750 |
| India | haryana | 4000 | 4750 |
| India | Himachal | 6000 | 4750 |
| India | UP | 7000 | 4750 |
| canada | toronto | 10000 | 15000 |
| canada | Columbia | 20000 | 15000 |
Create a measure:
Avg by Country = CALCULATE ( AVERAGE ( 'Table'[population] ), ALLEXCEPT ( 'Table', 'Table'[Country] ) )Hope this helps
David
4 Replies
- dedelman_clng
Community Champion
Create a measure:
Avg by Country = CALCULATE ( AVERAGE ( 'Table'[population] ), ALLEXCEPT ( 'Table', 'Table'[Country] ) )Hope this helps
David
Hi dedelman_clng. Thanks for your response. Will this work even if I am using all coumns from different tables (joins)?
